Viewing 15 posts - 10,831 through 10,845 (of 19,560 total)
Stefan Krzywicki (3/17/2011)
Brandie Tarvin (3/17/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
March 17, 2011 at 11:02 am
crookj (3/17/2011)
Ray K (3/16/2011)
CirquedeSQLeil (3/16/2011)
squareroot
Canal :crying:
Joe
Novocain
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
March 17, 2011 at 11:00 am
Are you now able to successfully execute the package and get desired results from BIDS?
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
March 17, 2011 at 10:57 am
You're welcome
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
March 17, 2011 at 10:12 am
Tom.Thomson (3/16/2011)
tosscrosby (3/16/2011)
DisarrayUndress
redress
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
March 16, 2011 at 11:40 pm
The best solution for this is to set the transaction log to a suitable size and not shrink it.
If you are concerned about the size of it, then change 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
March 16, 2011 at 10:17 pm
you may want to reset the SQL account password for that user and then try again.
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
March 16, 2011 at 4:39 pm
Is the package stored in msdb or on the filesystem?
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
March 16, 2011 at 3:53 pm
Steve Jones - SSC Editor (3/16/2011)
If you use Execute As and the service account for SQL Agent, what comes back?
Logging in from the account and executing the query direct in...
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
March 16, 2011 at 3:50 pm
Did somebody by chance try hardening the security on the server by renaming one of those groups or altering the permissions on one of those groups. Compare exact group...
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
March 16, 2011 at 3:06 pm
Ray K (3/16/2011)
CirquedeSQLeil (3/16/2011)
squareroot
access restricted
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
March 16, 2011 at 3:03 pm
Then it sounds like your service account is not a member of sysadmins or has been put only into the public role.
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
March 16, 2011 at 2:46 pm
Have you tried a proxy account?
Have you tested the query with your service account from SSMS?
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
March 16, 2011 at 2:41 pm
Daniel Bowlin (3/16/2011)
CirquedeSQLeil (3/16/2011)
squareCube....wait that is about SQL, or is it?
MDX or is that MX - which one has superbikes?
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
March 16, 2011 at 2:29 pm
If the files are on ServerA, they will move across the network to ServerB to be consumed into memory and then data pumped back across the network to insert necessary...
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
March 16, 2011 at 2:27 pm
Viewing 15 posts - 10,831 through 10,845 (of 19,560 total)