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
I use integrated security but believe I'm not administrator of Windows, I can't install a program, register a dll, ecc...
2003-06-26
It's the SQL Server, either the name or the IP address. If the name doesn't work it's due to a DNS issue (no name resolution). When you supply your login and password it doesn't go to any user database. All logins are 'confirmed' by the MASTER database. Once MASTER confirms the login it 'sends' you […]
2003-06-24
Its SQL2000 with service pack 3. The ODBC driver is old (3+ years) but its not that that is causing the problem. The old driver is the reason the IIs has to be on the same box as the ODBC driver wont look over the network for the accounting software. I was wondering if there […]
2003-06-23
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-06-23
There might be a script in the library here, if not it's easy to write. Setup a stored proc to scan sysprocesses and check the last batch against the current time. After some xx time, run a kill against the spid. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-19
1 reads
Reindexing is good - but it depends on how many inserts, updates, deletes you have every day. You may be able to get by with a job that runs sp_updatestats. A good way to choose candidate indexes is to look at your current queries. Look on the columns where you join tables and look at […]
2003-06-11
If the users can be stopped for 10 minutes, One simple solution is, detatch db and attach it back with only the .mdf file. .ldf will be created with default size of Model and you can set the max growth. This will resolve the problem Regards Fred
2003-06-10
1 reads
This command.... DBCC LOG (DBID/DBNAME, Type = 1/2/3/4) ...I can't seem to find it in BOL. What is the BOL topic if it exists, or is there any other info I could find?
2003-06-09
I would press the fact that you pay for complete service and they are not providing such. But check your contract from when you setup, if it fails to mention they block ports you may actually be able to force them on the issue. If they did not make a statement on blocking within your […]
2003-06-02
2 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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