2003-07-25
1 reads
2003-07-25
1 reads
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-07-18
Hi acudlip, quote: 1) drop the non-clustered indexes (takes seconds) - to avoid their rebuild when the clustered index is dropped. 2) drop the clustered index - takes 6 hours!! This is approx equal to the time it takes to build the clustered index - its a big table. how do you drop the indexes? […]
2003-07-15
Forgive me for answering my own question, but I just found the answer and will post it here in case someone else runs into the same problem. There was an SP in the source database that was renamed in Enterprise Manager but the name of the SP was still the original name when you edit […]
2003-07-07
Also check out this... qa.sqlservercentral.com/columnists/rsharma/copydatabase.asp It's a pretty good article and part way through it talks about moving logins from one server to another. -SQLBill
2003-07-07
...unfortunately not the browser merely hangs for a few seconds and then returns a blank page.
2003-07-07
Executive is nothing but SQLServerAgent. If you are using distributed transactions (Calling the remote stored procs on some other SQL Server and Distributed updates) in your application you might want to start the DTC with same service account. Yes you must restart the SQL Service to take place this change not the Windows
2003-06-27
1 reads
It sounds like you have a good idea of the operations that need to be performed. So, for now we'll make the assumption you can code the stored procedure. To learn how to kick of a proc on a schedule, search SQL Server Books Online for the phrase: creating jobs. If you need some help […]
2003-06-26
2003-06-26
1 reads
Hello Cheers and thanks for your attention Now If I execute by Query Analyzer the statement: SELECT * FROM [dbname].dbo.table_name_2 work, It's OK! instead SELECT * FROM [serverName].[dbname].dbo.table_name_2 not work! Bye bye Flavio
2003-06-10
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers