nikhil.verma (1/11/2010)

---

Is it advisable to schedule the DBCC SHRINKFILE before the backup happens. This will help in reducing the log file size and to release some space to OS as...

Not that this is going to help you - but I don't know of anyone who backs up directly to tape from SQL Server. The generally accepted method is...

What is the purpose of removing that access from the public role? What is it you are trying to accomplish here?

Take a look at VIEW DEFINITION in books online....

There were known issues in SP2 with the Check Database Integrity task and the Execute SQL Task losing database context. I believe this was also seen on the backup...

Yes, you could do something like that. Add an optional parameter and then you could have the procedure executed as:

EXECUTE dbo.MyProcedure @help = 'something';

Inside the procedure - check for...

You have to build your script to add the users to the restored database. You can build a script by querying the sys.logins table.

To grant access, you should create...

CirquedeSQLeil (1/8/2010)IMO - static ports. This will help to prevent connection issues due to port changes.

Every Instance must be on a different port - otherwise SQL server will have...

BSavoie (1/8/2010)

---

I guess stripping the time is the best bet. I'll stick with that. If I strip the time off the parms first rather than the doing it in the...

Even when the ports are setup as dynamic - SQL Server will attempt to use the port assigned the first time. If it can - it will re-use the...

bhoward 86472 (1/8/2010)

---

Getting your nuts busted a bit cause many of us have been there...not me of course 😉

Doesn't Red-Gate have some tools for recovery via the log file? I...

BSavoie (1/8/2010)

---

Sorry, I'm back to this again!

Lets say I have a table with "ArrivalDateTime" column.

And I have a stored procedure that will fetch these. Something like this:

create procedure FindArrivals

...

Yeah, the first couple of times I did too - not easy to see.

Edogg (1/8/2010)

---

If you look at the top of the KB article for the CU. It has a "view and request hotfix downloads" link at the top. Clicking on this takes...

Why not? There are cases (admittedly rare) where cursors are the *right* tool for the job....

Once you have more than a single-instance in...