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
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
I had this problem and I fixed it by making the user account that runs the SQL service a member of the administrator group. I was trying to run the service with less than full rights on a test box.
2003-06-04
Hi Crispin, quote: Just completed it. Not sure what I got myself into. Maybe now I will be getting emails asking if I am lonely... Short survery and useless if you ask me. I already receive those mails asking if I wanna be friend to ???. Short surveys I like best. I only did this […]
2003-06-04
1 reads
The good thing about my procedure is that I can save it as a package. I can repeat the process (after modifying it if necessary) to: copy to another server move another set of packages. Also it is fast and moving let say 100 packages will take not much more time than moving 2 or […]
2003-06-03
1 reads
Here is an easier procedure I found in technet: Step 5: How to Move DTS Packages Step 5 is optional. If DTS packages are stored on the source server in the SQL Server or the repository, you can move them if you want. To move DTS packages between servers: Save the DTS package on the […]
2003-06-03
1 reads
Steve, It is sql server 2000 standard edition, service pack 2. I feel like this started when we changed our email to microsoft exchange server but i can't say for sure. I checked my server logs and event viewew on the NT 4.0 server box and no messages. I guess I can reboot the box […]
2003-06-03
1 reads
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