I always use the following script and it works great. After the script finishes and the logfile is still bigger then you want, just run it again for a couple of times... SET NOCOUNT ON DECLARE @LogicalFileName sysname, @MaxMinutes INT, @NewSize INT -- *** MAKE SURE TO CHANGE THE NEXT 4 LINES […]
2004-03-24
We were hit with the same rude surprise when we migrated. Short version - keep DTS on 32-bit. It might run, but you are on your own if you do - untried, unsupported, etc.We kept our old 32-bit boxes as the DTS clients, then quickly made some of our packages dynamic so logging and connections […]
2004-02-26
For example, EXEC xp_sendmail 'Test', @query = 'exec sp_helpdb exec sp_helplogins'
2004-01-28
Okay; it's probably the foreign keys. What indexes exist for the eight tables with foreign keys referencing the RetailMember table? What DRI options (e.g. CASCADE DELETE) exist for those constraints?
2004-01-16
I want to do some audits of changes in the database. I would like to do this using triggers, but there will be updates to several tables in one transaction and I would like to be able to group all those updates in my audit tables. quote: I don't know of any way to do […]
2003-12-03
Maybe this would work: sp_grantlogin [@loginame =] 'login' sp_grantlogin sp_revokelogin Note that the SQL security account procedures and the NT security account procedures differ. If you got a snapshot of all of the logins/role membership/permissions for the NT accounts, and their NT account name has not changed, then you could scan through them and use […]
2003-12-01
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-11-21
2003-11-19
1 reads
Hey Mike, Make it simple, as the other person said, use constructed queries, thats basically, u will have to arrange the SQL statement with a string variable,let say @str, the have a string variable for SELECT in @str1, then FROM in @str2 and WHERE in @str3 and ORDER BY in @str4, So what u do […]
2003-08-30
Greg Larsen and guarddata, your TSQL suggestions work great as well. Thanks a bunch to all.
2003-08-20
1 reads
By Steve Jones
A customer was having some trouble getting started with Azure DevOps (AzDO) and building...
By Rob Sewell
In this post, we share the strategies and techniques we've implemented to ensure our...
By Steve Jones
I had a customer that was concerned about the fragmentation alert for indexes and...
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