Viewing 15 topics - 269,326 through 269,340 (of 284,211 total)
Topics
Started by
Posts
Last post
Is there a way to drop the objects on the linked server DB? Also any way to execute Select * in to…
2 replies
Hi, How do I tell which version (Standard or Enterprise) is installed on my SQL2000 SP3 server?
13 replies
I find the DTS Import/Export Wizard in SQL Enterprise Manager to be handy for moving objects into p…
2 replies
Buying a new data warehouse server, looking at storage. Option #1 is direct attach, probably a thre…
3 replies
If I currently have servers that the program files and data files were installed on the D drive - i…
16 replies
In creating a test environment by restoring a database as the test database, I've noticed the File …
4 replies
This answer implies that you would be moving the primary key constraint to the LAST_ORDER_DT also. …
6 replies
"Drop the primary key clustered index and create a new one on LAST_ORDER_DT" implies to me that you…
11 replies
I am exporting to Excel based on query against an SQL Server table and a lookup against an Access t…
7 replies
hi how can i import with dts a .sql file which contains sql statements like this: delete from tab_c…
9 replies
Hi, Is there any article on the physical space needed to shrink a database. We have 30gb database a…
2 replies
Does anyone have a script which will select the top x rows from every user table in a database? Th…
6 replies
create proc extractdata as begin tran if exists (select * from dbo.sysobjects where id = object_id(…
6 replies
I have a database aaa and i'm taking a full backup daily at 12 Am(I'm overwriting to the existing m…
2 replies
Hi, Is there any article on the physical space needed to shrink a database. We have 30gb database a…
3 replies
Viewing 15 topics - 269,326 through 269,340 (of 284,211 total)