Developer Newsgroups: SQL Server Tools

Help with a Query

Bernard - 12 Oct 2007 8:12 PM - 2 messages

What I am trying to do is the following: I have a web text box the will have a date format of "11/04/2007" but I want to query the database date field (mod_date) which format is "20071104". How ...

where can I get "Microsoft SQL Server Migration Test Toolkit" ?

chocolate - 12 Oct 2007 4:57 PM - 11 messages

hello, who can tell me where can I download it? thanks ºÇºÇ ...

Upgrade Advisor Trace Files

Michelle - 11 Oct 2007 4:03 PM - 4 messages

We have a purchased product. This product has a SQL Server 2005 Compatibility 'Update' but that update is lacking some fixes to make it compatible with SQL Server 2005. User testing has generated at least one error related to the use ...

Script to PRC

vanderlej - 10 Oct 2007 7:58 AM - 3 messages

Hey, new to this group. Anyway... I need a bit of help. How to script stored procedures in SQL2005 with PRC format? Thank you. ...

Extracting documents from a database

PhilHibbs - 9 Oct 2007 4:51 PM - 5 messages

How do I extract documents from a SQL Server database? I'm off ill so I don't have the table structure to hand but I'm pretty sure there's some kind of BLOB field and a text field with the document name, I'm ...

Management Studio keeps blowing up

Kyle Jedrusiak - 9 Oct 2007 1:17 PM - 10 messages

Within the last two weeks SQL Server Management Studio has started to blow up with a "Would you like to report this to MS" window. It's running on XP Pro. 2GB RAM and plenty of HD space. I have run a complete scan with Norton and Defender. I even ran a Checkdisk ...

Version Control SQL2k?

David Hay - 8 Oct 2007 7:40 PM - 4 messages

I didn't know where else to post this question so forgive me if this is the wrong place. I'm looking for a tool/tools to help with schema changes in SQL 2000. I was wondering if I could get the groups ...

SQL Server Management Studio w/ SQL Express?

Randy K - 8 Oct 2007 3:50 PM - 2 messages

SQL Express doesn't come with the Microsoft SQL Server Management Studio. Is it legal to copy the Studio to PCs running SQL Express? Thanks ...

Database Object Protection and DDL Auditing Tool

ddl_admin - 8 Oct 2007 12:58 PM - 2 messages

Folks, I would just like to share a database protection and auditing tool that has just been released: SQL CodeSecure is a database protection and auditing tool for SQL Server 2005. It provides ultimate protection for your database from unauthorized ...

Backup job reported as failed

BlackToe - 7 Oct 2007 5:13 PM - 5 messages

Using the wizard, I set up a maintenance plan to backup a few databases in MS SQL Server 2005. The plan does: 1) Integrity check 2) Database shrink 3) Rebuilds indexes 4) Backs up the databases 5) Deletes old backup files ...

Copy Database Fails in SSMS - Invalid Object Name

Charles Law - 7 Oct 2007 10:38 AM - 4 messages

This is a carry on from my earlier post about generating scripts to recreate a database. Instead of generating a database script, I just tried to copy it, using the wizard in SSMS. It fails in the same way my generated script did earlier. ...