Viewing 15 posts - 10,531 through 10,545 (of 19,560 total)
Have you tried relaxing the permissions for the share?
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
April 7, 2011 at 12:51 pm
GilaMonster (4/7/2011)
GSquared (4/7/2011)
San's making the classical...
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
April 7, 2011 at 12:47 pm
Hugo Kornelis (4/7/2011)
SanDroid (4/7/2011)
GSquared (4/7/2011)
Diagram it out on a piece of paper. Just a simple flow-chart. You'll quickly see...
Wish Flow charts where better here.
Temp Tables are logged...
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
April 7, 2011 at 12:46 pm
GSquared (4/7/2011)
Wayne, it was a good question (should I be smug that I got it right, or just ... nah ... I'll be smug about it).
We have words for 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
April 7, 2011 at 12:06 pm
GilaMonster (4/7/2011)
CirquedeSQLeil (4/7/2011)
I knew table variables and truncates were minimally logged and thought version store was too. I learned something new.:-D
Table variables aren't minimally logged. They are...
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
April 7, 2011 at 11:03 am
GilaMonster (4/7/2011)
WayneS (4/7/2011)
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
April 7, 2011 at 10:45 am
I'll put it out there that I missed it because I went with the none option (meaning all are logged based on question phrasing). I knew table variables 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
April 7, 2011 at 10:41 am
WayneS (4/7/2011)
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
April 7, 2011 at 10:30 am
UMG Developer (4/7/2011)
ljf3rd-1038030 (4/7/2011)
Obviously I cant keep recreating the role and the permissions.
If the role is being lost when you run your update scripts you need to look and see...
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
April 7, 2011 at 10:17 am
Craig Farrell (4/6/2011)
CirquedeSQLeil (4/6/2011)
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
April 6, 2011 at 11:58 pm
Jeffrey Williams-493691 (4/6/2011)
CirquedeSQLeil (4/6/2011)
Jeffrey Williams-493691 (4/6/2011)
The job_id is stored in the table: sysmaintplan_subplans...
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
April 6, 2011 at 11:56 pm
2000 and 2005
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
April 6, 2011 at 11:51 pm
Good to know.
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
April 6, 2011 at 11:42 pm
I'd check MSDN or your account rep. I know SQL 6.5 is available for download there.
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
April 6, 2011 at 11:34 pm
I've seen permissions disappear from a simple alter of the proc as well (not drop/create). I think the safest bet is to make sure you apply permissions to the...
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
April 6, 2011 at 11:31 pm
Viewing 15 posts - 10,531 through 10,545 (of 19,560 total)