you could convert to int, which would be the number of days since the beginning of time(according to sql server that's 1900-01-01 00:00:00.000)

SELECT getdate(),CONVERT(int, GETDATE())

2007-10-03 23:07:05.640 ...

you get a rows affected for every sql statement performed. that means select,update,insert or delete statements each return the rows affected.

sounds like you had either a cursor or loop that...

you cannot rename an instance, it has to be uninstalled and a new instance with the correct name needs to be created. that means backing up non-system databases, and then...

also, a DTS job is slower thant he time it takes to backup, copy and restore a database, as well as being prone to the changes you are seeing.

I'd recommend...

the thing about color is that you MUST enter the double quotes to get it to work.

input = #0000FF is BAD

input = "#0000FF" is GOOD

you are right....the actual permissions are stored inside the database, and not in any master table.

this is by design, so when you backup and resotre, the permissions for the objects...

it's handled automatically by the operating system;

you might have one nic that has an internal IP for your network, lets say 192.168.1.50

the other NIC might have an IP address on...

we had a similar issue in our shop...we needed to merge two databases together, with each table having different data, but possibly the same identity() values.

we had to build...

Jeff was just fiddling with it...add a reply, emails get sent, delete teh reply, the link in the email can't find the posted reply. expected behavior.

WHY he was testing, we...

Jeff Moden (10/1/2007)

---

Heh... those are fun but I like the real-life questions that teach why or why not to do something... for example...

1. How many internal rows will be...

this would give you the sample structure to test each column in a single pass...is that what you wanted, or did you want where an entire row was null?

select SUM(CASE...

from what i remember Clipper was just a Visual Foxpro, right? so it's simply a .DBF file you connect to using dts and import the whole thing:

Enterprise Manager, Select database...Right...

you can restrict access to executables and such via NT permissions and Active directory.

Once connected, unless you restricted his access to some objects, he's pretty much got access right?

if he...

creating and deleting replys, it looks like from my forum emails.

Serg is right; what is your trigger doing? Is it calling a stored procedure or something ?Is it using spOACreate/xp_cmdshell? trying to email something? does it declare a variable? does...