Viewing 15 posts - 13,516 through 13,530 (of 19,560 total)
GilaMonster (6/21/2010)
striker-baba (6/21/2010)
And I am trying to insert data through a linked server from a remote test server into my prod server.
It would have been useful if you'd mentioned that...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 21, 2010 at 7:54 am
D.Oc (6/20/2010)
CirquedeSQLeil (6/15/2010)
Gianluca Sartori (6/15/2010)
Paul White NZ (6/15/2010)
Jan Van der Eecken (6/15/2010)
Paul, Good Luck to New Zealand in their game against Slovakia in less than 4 hours from now.
Thanks Jan,...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 20, 2010 at 10:21 am
ALZDBA (6/20/2010)
- how do you actually insert ? using an sproc ? (check if it uses the execute...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 20, 2010 at 9:02 am
Have you tried to re-grant yourself the permissions?
http://msdn.microsoft.com/en-us/library/ms187965.aspx
The link provided will show how to grant permissions.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 19, 2010 at 11:16 pm
It isn't possible.
Can you select or update on the table in question?
edit: Fixed typo.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 19, 2010 at 8:28 pm
It seems that the login you are using to run the insert does not have adequate permissions in the database. Are you sure you are logging into SQL Server...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 19, 2010 at 4:43 pm
Ninja's_RGR'us (6/19/2010)
ssms
connect to reporting engine
righ click on the report server name
properties
logging.
check activate. If you chose not to delete...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 19, 2010 at 4:39 pm
Simple thing to do, makes a lot of sense and saves a lot of time down the road.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 19, 2010 at 4:35 pm
Moving to the cloud should make for an interesting future.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 19, 2010 at 4:28 pm
smitty-1088185 (6/16/2010)
Even though a add the users to the SQLAgentOperator...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 19, 2010 at 4:24 pm
As the others have said, you may not be able to use some of the DMVs. I also have just migrated a lot of 2000 databases to 2008 and...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 19, 2010 at 4:16 pm
Jeff Moden (6/18/2010)
Greg Edwards-268690 (6/18/2010)
WayneS (6/18/2010)
Wednesday, I updated a test box to SQL 2008. Pretty old (> 9 years)...
Last night, the drive controller failed spectacularly (sparks, smoke, everything),...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 18, 2010 at 11:09 pm
WayneS (6/18/2010)
Wednesday, I updated a test box to SQL 2008. Pretty old (> 9 years)...
Last night, the drive controller failed spectacularly (sparks, smoke, everything), completely corrupting the HDDs...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 18, 2010 at 11:06 pm
WayneS (6/18/2010)
Lynn Pettis (6/17/2010)
Checked out a thread where one of my blogs was referenced, feels good when it helps someone solve a problem. 🙂
I frequently reference your blog for...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 18, 2010 at 3:54 pm
Chris Morris-439714 (6/18/2010)
dbowlin (6/17/2010)
Excelsior!Fat Freddy's Cat.
Fertility Pills!
Quintuplets?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 18, 2010 at 8:29 am
Viewing 15 posts - 13,516 through 13,530 (of 19,560 total)