Insert into TableC values
select X.column3, B.column5, B.column6, X.column4, Sum(x.column8) Sum(x.column9) . . . . Sum(B.column10)
FROM [TableX] X...
If I upgrade my reporting server from SQL Server 2005 to SQL Server 2008, will there be any change in the folder structures created by SQL Server...
Please let me know if we need to do any RDL file changes for reports, if my underlying data source chages from SQL Server 2005 to 2008
I have to upgrade SQL Server 2005 EE 64bit Active/Active cluster on Windows 2003 to SQL Server 2008 EE 64bit
Is it recommended to upgrade the...
Me along with another friend used to maintain the Production servers and databases of leading MNC Bank.
Since he is System DBA and not SQL Server...
I need to keep all the AD details (groups,users,..etc) in my database.
One way is to create a linked server to ADS service and get the info
Will SQL Server 2005 will support to connect to SQL Server 2008 database
High level guidance will be very much appreciated
Our SQL Server database hosts around 1.1 billion data occupying 450 GB of memory. Runs in a single server without partition.
Is the possible to set up clustering as described below
Set up SQL Server 2005 Cluster
Install two instances of SQL Server in this cluster in...
We are trying to install the SQL Server 2005 Enterprise 32Bit Edition in a clustered SQL Server 2000 environment and keep receiveing the following...
I am getting the following error when I run the command
ALTER DATABASE mirroring
SET PARTNER =
I have a table partitioned on a column on which i have nonclustered index.
I have clustered index on another column.
In this scenario, how the...
I need to create a surrogate key in one of the transaction table in my db design.
Two options are
a.Create an identity key
b.Create a column...
How of find out if SQL Server installed is 32bit or 64bit edition?
What is the alternative in SSIS 2005 for Using Dynamic Properties of DTS 2000
Thanks for any help
We are facing problems while creation reports from SSRS working with DB2 as a database. Stored procedures defined on DB2 returns data to Reports....
We are planning upon using the scheduling feature of SQL Server RS 2005 in our project
The report schedules stored in the Database should be...
I have a job which calls a DTS package
This DTS package runs a view and inserts the result to a table
The job step which calls the DTS package...
My bcp is giving the following error
"Query hints exceed maximum command buffer size of 1023 bytes (1354 bytes input)."
Anyway to over come this?...
I have a DTS data transfer task. In the option tab I see the fetch buffer size as 9999.
BOL says that it is the number of rows to fetch from...
Separate names with a comma.