Find missing Foreign Keys by name, only reference single column primary keys which are on top of an identity,also find where column names reference table with column name ='ID'.
2016-02-01 (first published: 2016-01-21)
1,046 reads
This script returns the date for the most recent log/full backups and checks if a DBCC CHECKDB has ran within a week.
2015-07-23 (first published: 2015-06-23)
1,288 reads
Prevent overlapping of time events with an indexed view.
2013-11-26
4,225 reads
In the course of giving my security presentations over the past year, I've learned that quite a few folks have never seen the C-I-A triad before. The C-I-A triad stands for...
2009-04-27
4,580 reads
2008-09-30 (first published: 2008-07-24)
870 reads
Hello everybody!I am using SQL Server 2000 and I replicate a database using snapshot replication (Enterprise Manager). On the publisher side, all my stored procedures have been granted EXEC permissions. Once the replication occurs, I loose all the EXEC permissions on the stored procedures on the subscriber side.Anyone has an idea?Thank you in advance for your […]
2004-09-14
2 reads
Try changing the ADODB cursorlocation to be adUseClient. Then you should be able to get a recordcount. The problem is the recordcount uses client always and when the cursor location is on the server it can't get a count.If the above gives a -1 add re.movelast and rs.movefirst and then check record count.
2004-07-23
I agree that No is the answer to your question, however I wanted to see if anyone could give me a clue as to why a Delete tablenameworks and a Truncate tablenamedoes not. It give me the error that a FK error exists, but gives no ref to the FK and I was unable to […]
2004-03-04
I'll go also for wz700 suggestion. In fact that's what I use. Trigger script generation based on schema. And it does not matter if you have 500 tables and 200 fields per table that's what scripts are for, right?
2004-03-03
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-19
This month’s T-SQL Tuesday is hosted by a dear friend, long time SQL Server...
By Steve Jones
I almost missed this month, so this is also a good #SQLNewBlogger post. I...
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
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