ps (12/21/2008)

---

Do you mean we shud have a generic backup job that takes tran log backup for all databases(even for newly created ones)? in this case i dont think i...

And, if you decide to follow 'timothywiseman' solution - don't forget to remove any indexes and recreate them on the new columns, as well as the foreign key references (if...

I would bet anything that the job is stalling on the WAITFOR command. 😛

ps (12/21/2008)

---

How about writing a simple backup statement at the end of database creation! the other point i mentioned in initial posts. I think that should do the needful for...

That's kinda what I thought - so, your choice is simple. You need to create a job that checks for newly created databases and, if found - back them...

RBarryYoung (12/21/2008)

---

Pradeep's point is well taken here: There is no point to backing up the database immediately after it is created, because it does not have any data yet....

Look in the SQL Litespeed help file on the command line utility - and extended procedures. I don't have the reference available right now - but there is an...

So, the first thing we need to do is define the schema:

CREATE SCHEMA DELT AUTHORIZATION dbo;

Then, we would create the synonyms:

CREATE SYNONYM DELT.ACCT AS REPORTDB.DELT.ACCT

CREATE SYNONYM DELT.ORG_ACCT AS REPORTDB.DELT.ORG_ACCT;

Create the...

SSRS outputs to Excel 2003 format - which has a maximum number of rows of 65357 (I think that is the number). If you have over 900,000 records -...

Mike - are you sure all other connections are using the FQDN when connecting? Are you sure that all other connections are using a matching SPN record to connect?

You can use a CTE or a derived table - here is an example using a CTE.

;WITH myCTE (field1, field2, field3, ...)

AS (SELECT {complicated sql...}

...

I would recommend using synonyms for this. Much easier to manage and change as needed. Example:

-- create a schema for the synonyms, not really needed - could use...

Lynn Pettis (12/19/2008)

---

Dejanette,

I am sure you would help if you could. My problem is with applying SP 3 to a multi-instance x64 server running SQL Server 2005 Developer Edition.

If...

Is that procedure the only procedure doing any inserts? Can you confirm that the inserts that you see that are blocked are all related to this procedure?

If so, that...

Yes, you can have it both ways. And don't worry - most of us are confused about it also. I only know a few pieces of it myself.