If you need to delete everything from the table then do a truncate table, it is minimally logged so it shouldn't fill up the log. If you wish to maintain...

If you have crystal reports you can use the crexport tool http://www.rainforestnet.com. Then make a bat file and schedule it with windows task scheduler. Or use MS Access and create...

I have a related question. I need to do a big delete of probably 40,000,000 rows from a 46,995,209 row table. I can't use truncate as I need the...

I gave up on ER Studio as it would not reread changes to the database and was a nightmare to maintain. Instead I use SQL Servers extended properties for tables,...

Don't know if I'm considered young or not anymore but I'm 31 married 9 yrs, no kids and although my wife rarely touches SQL she knows it better than most...

what about SQLEXECMS, it works pretty well for me and the price is right.

http://www.laplas-soft.com/exec-intro.htm

I use a stored procedure to kick off Cdosys mail. It is SMTP only - no receive. Its very simple and requires no client on the server. The only thing...

I have done this exact thing and found it worked much more easily than expected.

1. backup db's, including master - just in case

2. down server remove drives

3. Hookup drives...

Yikes, this will run terribly slow, especially if the column is not indexed. I would recommend you make a table to hold the "in" values, then instead of doing an...

If you can ping the machine's ip - In your registration are you registering by using the machines IP or it machine name? If it is in a different network...

You could spend some time creating a cursor that loops through and selects into a table. Or you could cheat, go to excel put in a field name in A1...

In trying to run the trace, I need to limit it to just events in the test database. When I set a filter on database name, it seems not to...

Correct you will have orphaned users if you do the attach or restore options and the logins are not in Master, if there are few users, you can set the...

I assume you mean multiple instances of SQL server on the same system?

If this is the case, there should be no issues just make sure you use the full...

You may also want to look at your database settings. For example changing from full logged to bulk logged or simple - this will have reprocutions on your backup, but...