I'm using SSIS and SQL Server 2005. I have a database field type is an integer; what data type should I use in the flat file connection manager? The data that is being imported is 3 numeric va...
I am implementing Sql Server Database Mail. I have this completely setup and working. Where I am having difficulty is try to checking the status of submitted messages in the same SP that cal...
I have a field named ErrorMsg that contains error messages. I need to extract the badge number from this field. The error message I need to extract from typically looks like this:
Error [1...
Im on my database and i want to move one of the tables to another filegroup...i have all filegroups set up...now i want to move tables from PRIMARY to REPORT_DATA filegroup
I can do this in...
I recently installed SP2 on our SQL Server. Now my backup Database task fails. I had it set up for all user databases, Transaction logs. Now it fails immediately with the error:
Error: T...
Can SQL 2005 Management Studio (using say, the Analysis Services MDX Query) make a connection to a Cube developed in SQL 2000's Analysis Server?
When SSMS tries to Connect to Analysis Servi...
Hi,
i have installed SQL SERVER 2005 on my XP machine.
After installtion i am unable to locate Enterprise Manager to create and manage Databases ?????
On windows 2003 server...
Hi experts,
How to write a query that returns B and D if the table's data looks like this:
(I want ID that has more than one Type)
ID Type
-- ------
A 1
A 1
B ...
I am not sure how to word this as I know nothing about Network protocol but I am told my Network guy is going to come over shortly to ask me some questions about what is the difference between...
I have a database with two tables.
One table is labeled clients, the other orders.
The clients table has an id column that is the PK. The orders column has a column called client_id tha...
Is there a way that I can programmatically identify when the log file for a sql database is about to get full. That way we can fix the problem, before it becomes a problem.
My stored procedure code is returing the following errors and I can't see why.
Msg 156, Level 15, State 1, Procedure General_Release, Line 10
Incorrect syntax near the keyword 'AS'.
Msg 1...
Stupid question.....What is the best way to write this to get back the number of accounts called. This brings back the correct info...
Heres the query
SELECT COUNT(DISTINCT dq.account_id) ...
How to convert a table1 to table2 in sql server 2005
Table1
Case Num ID rec_date
3662099 UF 2007-08-01
3662099 UF 2007-08-08
3662099 UF ...
I am adding an a new instance to an existing sql 2005 cluster. The porlbem I have is with the IP Address. the current instances are on 10.64.12.x and the address I would like to use for the n...
Over the past few months I have been developing a new MS Access 2007 "project" as a front end to a new SQL Server 2005 Express database,
This is all being done on my Dell laptop (computer nam...
If there is a table with the following structure:
KeyCol Data
12345 AAABBBCCCDDDEEE
23456 FFFGGGHHHIIIJJJ
34567 QQQWWWEEERRRTTT
How can the data be extracted in the following form...
Hello eveyone,
I need a query that fills my table automatically. The table has collum named Quantity
The data that must be in the table is as follows:
1
2
2
3
3
3
4
4
4
4 and ...
It it the same in MS SQL, i need to get all my tables names and data would SHOW TABLES work in MSSQL
Hi all, I am trying to create a column on the fly in my sql statement. Here is what I am trying to do:
I have two columns 1) Jobnum:Float 2) Part: varchar. I am trying to create a column in...
I have the following query...
SELECT Year(TransDate) AS TransDateYear, Month(TransDate) AS TransDateMonth, SUM(Amount)
FROM BudgetTransact
WHERE TransDate BETWEEN '1-1-2006' AND '1-1-...
How to move Database in SQL 2005 test region server to Sql 2005 Production region server please send me the steps to follow
The data is as follows
SID NAME
26 ABC
77 ABC
79 ABC
17 ABC
30 ABC
47 ABC
39 DEF
65 DEF
56 GHI
64 GHI
28 JKL
62 JKL
96 MNO
66 MNO
75 PQR
63 PQR
I want to return the res...
Using SQL 2005 I have a table with 3M rows...
When I try and modify it I get the following error
- Unable to modify table. Timeout expired. The timeout period elapsed prior to completi...
Basically, I have a column called "SHIFT" that I need to perform an update on based on the value of another column [MESSAGE_TIME]
If the TIME in [MESSAGE_TIME] is between 7AM-4PM set [SHIFT...
