I am using SQL Server Express 2005 on a Windows Server 2008 server.  I
noticed that the included Windows Server Backup fails if the SQL Server
VSS Writer is running. I stop it, backup runs fine.
Is that the way it's supposed to work? Also, VSS Writer service is set

I'm using SSMS with SQL 2005 SP2. I've been trying to create a script using
the "Generate Script" wizard that only has Drop Index and Create Index
commands. I don’t want the create table command. The database has about 500
tables and it will take me hours to generate a FULL ...

I 've just installed SS 2008 Developer Edition in my machine. It is running
side by side with a SS 2005 Developer Edition.
After installed (the setup worked fine without problems) I got  the
following error when  I tried to connect to a server:

I'm using SQL Server 2008 and I'm writing Queries in SMSS.  I find that if I
add a new object (e.g. a new Table) to the database, the intellisense does
not recognize it (i.e. it puts a red underline underneath it) until I exit
SQL Server and restart it.  My queries run OK even ...

Hi I need to purchase some Sql software to compress  and quickly backup data
files, proactively monitor a whole range of servers in real time and I need
auditing at the log level for ddl events and rollbacks in case of emergencies.
Idera SQL Diagnostic Manager  --for monitoring

Help, in SSMS 2005 I get the following error when I try to view the
securables on the Database Role Propery dialog.
If I click the Add button and on the Add Objects popup dialog select "Add
all object belonging to the schema..." then select the schema with the same

All,
I have two Vista SP1 machines that have SSMS 2005 installed on them.  These
two machines (both used by developers) cannot see my new named SQL cluster
instance when trying to connect using SSMS.  Every other PC in the office

Any one konw the step how to restore sql 2000 database to sql 2005
i got error when i restore backup.bak(backup from sql 2000) file to sql 2005
i right click then choose task , restore

Hi,
This is my first post.
I backed up my registered servers on SSMS 2008, including passwords,
re-installed my OS from scratch, and imported the server list.

Hi People,
what tool/how do I generate database diagrams/schematics for a sql 2000 db?
I need to see tables, relationships etc.
I only have Enterprise Manager at present.

Here's what my data looks like:
"12312331        ","DOE, JOHN","3423423",0,1900-01-01
00:00:00,"","@@
","","JOHN DOE PROCESSING PLANT"

Any time we try to create a backup of a database using any method, including
the backup option on the All Tasks menu, the backup never starts but just
sits there with the word executing.
We have made backups and I am not sure what would have changed to prevent

I am looking for any tools capeable of repairing or recover data from a
corrupt (LDF) log file. I have a situation where my mdf and ldf files were
damaged after a hard drive failure. I was able to recover data from the
damaged (mdf) data file however not all of the information ...