I was thinking along the same lines...it might not be owned by dbo:

select

schema_name(schema_id) as SchemaName,

name...

the default database assigned to the login CORP\shilpa was dropped; change it to master adn try to log in again.

you can't.

once a person connects to SQL server, additional verifications are not possible from SSMS.

So if they have permissions to perform a a backup or a restore, you can't make...

how does a row number example perform?

SELECT

Server_Id,

Data_Timestamp

FROM

(SELECT

ROW_NUMBER() OVER (PARTITION BY Server_Id ORDER BY Data_Timestamp DESC) AS RW,

...

just a copy paste error...you left the column name attached to teh table name:

Insert into #FullDataGrid

Select '', createdtotal,'','',''

from #datecreated

INNER JOIN #DateCreated.CreatedDate

on #MasterDate.Date = #DateCreated.CreatedDate;

wow...changing that setting that i posted the screenshot of is SUCH a bad idea in SQL server.

testing that, i updated one row in a table, and saw i got...

to follow up on what Pablo said, here's a simple example:

CREATE TABLE WHATEVER(

WHATEVERID INT IDENTITY(1,1) NOT NULL PRIMARY KEY,

DESCRIP VARCHAR(30)

)

INSERT INTO WHATEVER(DESCRIP)

SELECT 'APPLES' UNION

SELECT 'ORANGES'...

even a filegroup backup might not be all you need; if all the tables are backup up in a file group, and then a change occurs to one of them,...

just the methods you probably already know:

SELECT INTO MyTABLE_bak FROM MyTABLE, or if you want to put them in a different database, SELECT INTO SELECT INTO SpecialDatabase.dbo.MyTABLE_bak FROM...

well i found a post stating the obvious: adding debug stuff like PRINT statements would slow down a proc, and forgetting to sue using SET NOCOUNT ON to avoid extra...

David Paskiet (9/2/2011)

---

As I remember the article, that is the root of the problem. Due to the large block, the compiler/execution plan cant do it's thing properly. so...

can you get an execution plans of the same proc with and without the huge comment blocks? that would be where i'd look first, i think...there's GOt to be ...

comments are ignored by SQL server completely...it's much more likely that because you edited the procedure, it was recompiled,a nd the recompilation made a better plan, which executes faster than...

glad i could help!

you can try to get fancy, and do something...

erkan.erbil (9/2/2011)

---

On 08/31/2011 between 13:00 - 14:00 o clock on PROD Servicemanager DB data in Tables XXXXXXM1 / XXXXXXM2 were deleted. We don't know how and by whom.

Appserver Logs showed...