I have made an update of this script http://qa.sqlservercentral.com/scripts/Metadata/64603/. the new version includes can generate 4 stored procedures for every table in a database
2013-01-08 (first published: 2008-10-23)
3,192 reads
use metadata to generate basic create procedure statements for insert update and select
2008-11-22 (first published: 2008-10-10)
3,808 reads
Just one way of testing for a linked server based on data within your database.
2011-09-16 (first published: 2007-08-07)
2,594 reads
We do use UDT either. I think it is better to use strong Entity/Attribute data modeling software and let the foreign key migration enforce the data conformity. For non-keys we use LOGICAL ONLY UDT but translate them to standard data types in the physical model. We use ERwin. It is a little pricey but I […]
2003-08-08
What's a "TIME ZONE" datatype? I mean, in what DBMS is it valid? Cheers, - Mark
2003-08-06
I've never heard of a change of password having such an effect. Your Windows account didn't change at all did it? Eg. Account deleted and then added back in with the same name? Or maybe account moved to another domain? Cheers, - Mark
2003-08-02
Here's one problem with your script: and Fname LIKE '%%%' First, this selects ALL data from Fname. Second, it overuses the %. Are you trying to get everything from Fname? If so, delete that line. Are you trying to get Fname where there are only three characters? If so, change the theree %'s to three […]
2003-07-31
Hi there Sounds like it could be an ODBC log. You might this link useful: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q268/5/91.ASP&NoWebContent=1 If that doesn't help, my first step when investigating performance problems is to check memory usage. Try using to the Windows Performance monitor to check the sql server Buffer Cache Hit Ratio - Microsoft recommend that this should be […]
2003-06-13
Hello Crispin, quote: A guy started working here who had never heard of google. He asked was it good. To demo it, I searched on "How do I wipe my @55" being serious. What does 'How do I wipe my @55' mean. Is it something X-rated? Cheers, Frank
2003-06-11
One thing we found was that the disk that the data files are on is extremely fragmented (data area - > 90%, free space - 5%) Can this cause the problems with accessing the #tables? We didnt' notice any slow down accessing regular table, only #tables.
2003-06-06
Full documentation on the Undercover Catalogue can be found HERE We’ve spotted a bug in...
By Steve Jones
With my new laptop, one of the things I realized I’d forgotten to do...
By Steve Jones
This month we have a good invitation from Deepthi Goguri, where she asks us...
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