|
|
Browse by Tags
- "Database Mail"
- .net
- 2005
- 2006
- 32 bit on MS Win2003 R2 Enterprise server / Clustersyste
- 64 bit
- 8.0
- 9.0.3042
- 9.00.3042.00
- access
- Access 2003
- Access 2007
- Access adp
- Analysis Services
- asp.net
- backup
- C#
- coldfusion
- Crystal Reports
- database
- Database Mail
- Datasets
- Error: 18456
- Event Type: Error
- Excel
- Exchange 2007
- export
- express
- Express to Workgroup
- fast
- file exist
- Firebird date
- follow.object.hyperlink
- For Loop Container
- Foreign Key Constraints
- formatting
- Formatting Date parameter on SQL Report Server
- full text catalog
- full text indexing
- full text search
- grants
- hierarchies
- hierarchy
- How will we know which job is using a particular table.
- HP
- HTML
- hyperlink
- idera sqlsafe
- IE
- IE7
- IIS
- linked server
- Local Instance
- Log Files
- matrix
- MDX
- Merge Replication 2005 to 2005
- Micorosft
- Micorsoft Access
- Microsoft
- Microsoft SQL
- Microsoft SQL Server
- Microsoft SQL Server 2005
- MOSS 2007
- MS SQL Server
- mssql
- N/A
- olap
- permissions
- Project Server 2007
- replication
- reporting
- Reporting Services
- Reports
- Server 2003
- SP2
- sql
- SQL Query
- SQL Reporting
- SQL Reporting Services
- sql server
- SQL SERVER 2005 REPORTING SERVICES
- SQL Server 2008
- SQL Server Reporting Services
- SQL SERVER REPORTING SERVICES 2005
- SQL Syntax
- SSAS
- SSIS
- ssrs
- SSRS 2005
- Stored procedure
- T SQL
- TSQL
- T-SQL
- VB.Net
- visual studio
- Visual Studio 2005
- VPN
- Windows Server 2003
- xml
-
Split flat file into 2 excel files SSIS
I need to split a flat file into two excel files. No conditions except maybe if more than 40,000 rows then split. Otherwise just need two files. -
How will we know which job is using a particular table.
There are more than 100 jobs running thro' sql agent. I have 2 tables and know all the stored procedures that are using these 2 tables. Now i would like to know the jobs that using these stored procedures or tables. Can some please suggest me a process? -
sql backup on MOSS 2007 team sites failing
I have a weekly full backup, daily differential backup schedule on my databases on my database server. Currently, all user databases are being backed up under this plan. I have more than 50 databases on this server. The only items that are failing backup are the MOSS Team sites database in production... -
SQL Query - Ignore row if there's letter in a field
Hello Experts, Is it possible to filter a row if a particular field has letter? I have a field called ID that support both alphanumeric. However, I would like to filter out any ID that has letters. -
SQL Update or Insert from another table
I am trying to bulk insert a csv file into a SQL table. However, if the record already exists i want it to update, not add another one, and if it doesnt exist then i want it to insert. I have so far got it to bulk insert into a table called TAPELOAD. Then i want it to update current records in the table... -
SQL Server 2005 error Incorrect syntax near '='
I'm trying to run a UNION query from MS Access that calls on a SQL 2005 datbase and receiving an error message that reads: Incorrect syntax near '=' I've tried several variants but currently the code looks like this: SELECT dbo_Tracings.*, [SBTerritory]=[STTerritory] AS Difference, dbo_Tracings... -
My SQL Server 2005 database is under a SQL Injection attack. Am I using CFQUERYPARAM correctly?
Hello. My SQL Server 2005 database is under a SQL Injection attack. The attack finds the column that comes after the Primary Key in each table, and erases that column and populates it with: http://94.102.52.27/urchin.js' > I am in the process of changing usernames and passwords for all of my clients'... -
Query to Group Time Punch Data by Date
I've been playing with this for a few weeks but haven't solved the main problem yet. When I query the time punch table I get a column with punch dates and a column with associated punch times but what I want to display is a single row for each date with that days punches in separate columns.... -
SQL String Concat with XML PATH() function. MS SQL SERVER 2005
Table: LS_Notes acctno patno seqno textdata 11 1 1 8/29/05 KL WANTS 11 1 2 SUIZ SHE WILL SCHEDULE/ 11 1 3 9/15/05 SENT PREP 11 1 5 10/13/05 SENT COPY 22 1 1 1/3/06 CIGNA POS ID 22 1 2 800-244-6224 CLAIMS PO 22 1 3 SENT PREP INSTRUCTIONS The ultimate goal here - is to concatenate all of that particular... -
Concatenate 2 tables Rows Results into 1 string
Hello experts, I'm trying to create a stored procedure in SQL 2005 and here is what I'm trying to do. I have 2 tables: OrderHeader and OrderDetail. The ordernumber is the key on the orderheader table and the FK on the orderdetail. Rows look like this: OrderHeader: Orderumber Customer -------...