Perhaps you are the only user, but have multiple connections. This happens to me when I have a QA window open on a DB and try to restore the...

Good point. If I add that to the script some day, then I'll make sure I post it.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my...

Yes it is true you can use rebuildm.exe to rebuild that master database and all system databases, but then you have to restore your databases from a backup, or reattach...

I've kind of done that. What I build the job one time. Then every time after that I dynamically build the steps, and execute the jobs. I...

To be honest with you I had the same problem a few years ago, and some kind sole told me how to get this to work. If I could...

Well this work for you.

use pubs

select count(distinct(pub_id)),

count(distinct(pub_name)) ,

count(distinct(city)),

count(distinct(state)),

...

quote:

---

I need to get a count of each distinct value in all the columns in the publishers table.

I think the only way...

Here is an example that takes values from prior row, based on ID. Maybe something like this might work:

create table abc (id int, v1 int, v2 int)

insert into...

If all you want is a the osql command to build a dos script file then try this:

osql -E -S<servername> -Q"print 'backup database northwind to disk=''c:\temp\northwin.bak'''" -o c:\temp\bck.sql

If all you...

I don't know. How are you processing through your records (programatically)? Send sample code might help.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website...

Just put you OSQL command that runs the backup in a .bat file, and then make that file a shortcut on your desktop.

Oh that is probably what you where...

When you have a row, save the column values in a local variable. When you get to the next row, if it is null then replace it with the...

Don't think so. I think it would be a relatively easy task to keep track of the number of records fetched while you are fetch each records via a...

Today I ran across and interesting function "objectproperty". Remember the HACK I wrote to determine if triggers where disabled, well I would suggest you change you code to use...

Looks like lots of good methods to accomplish the samething.

Betsy - I would like the script that uses the linked servers.

Gregory Larsen, DBA

If you looking for SQL Server...