SQL Server Tools

I'm starting to work with Microsoft Accounting which uses SQL 2005 database. I'm going to use it's database structure (some tables, SPs etc) in my database on SQL 2000. Data file has an extension sbd. It's not compatible ...

I have a number of scheduled jobs running on a server that normally run without any problem. However, on occassion, like yesterday, they simply stop running. The SQL Server agent is running and no errors are occuring anywhere but the jobs simply don't fire off. For example, I have a job that contains ...

Using SQL Server 2000 sp4. Hi, Consider the following code : == create table dbo.t2 (id int primary key, c1 int) -- there are no rows in t2 GO CREATE proc dbo.p2 as declare @i int set @i = 0 while @i < 1000 begin ...

Hi, Is this the correct thread for questions on SQL Profiler? If not please direct me to the correct thread. Cheers! My question is, when setting up the filter, how do you use Lke & Not Like? eg. If I have two databases DB1 & DB2. ...

We have a large, complex, old database running at 6.5 compatibility level. We want to raise it to 8.0. It would be an extremely onerous task to manually check for any issues. Is anyone aware of a tool that can do this? ...

Hello, I'm looking for a way to extract system catalog information from out databases to an external source (Excel or Visio).  Is there a built in procedure for this in SQL 2000? Or do I need to run schema view and then copy ...