Viewing 15 posts - 9,676 through 9,690 (of 19,560 total)
Do you have permissions to the specified drive location?
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 16, 2011 at 11:08 am
Elliott Whitlow (6/16/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
June 16, 2011 at 10:34 am
Ninja's_RGR'us (6/16/2011)
SQLRNNR (6/16/2011)
I have had similar happen to me - rebuild from scratch as Ninja said seems to work.The the default fix for most M$ products :hehe:.
Unfortunate, but rings true....
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 16, 2011 at 10:22 am
Daniel Bowlin (6/16/2011)
Brandie Tarvin (6/16/2011)
Daniel Bowlin (6/16/2011)
Brandie Tarvin (6/16/2011)
Brandie Tarvin
PneumonoultramicroscopicsilicovolcanoconiosisSQLRNNR (6/15/2011)
Now what does it mean?It's a lung disease caused by silica.
But can you pronounce it?
Sure. Pneumonoultramicroscopicsilicovolcanoconiosis.
If you didn't hear...
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 16, 2011 at 10:01 am
I have had similar happen to me - rebuild from scratch as Ninja said seems to work.
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 16, 2011 at 9:48 am
wow - cool feature. Learning something new.
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 16, 2011 at 9:41 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
June 16, 2011 at 9:13 am
I thought you said you had set it up on a different server already prior to this error. That was the other server I was looking for the information...
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 16, 2011 at 7:16 am
Jeff Moden (6/15/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
June 15, 2011 at 5:40 pm
Setting fillfactor can be of benefit to your system but could also be a detriment. It's not something you should set all one way or the other. You...
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 15, 2011 at 5:28 pm
Run this on both servers and let us know the results.
select SERVERPROPERTY('productlevel') as SPLevel,SERVERPROPERTY('engineedition') as EngineEdition
,SERVERPROPERTY('edition') as SQLEdtion,SERVERPROPERTY('productversion') as SQLVersion
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 15, 2011 at 4:47 pm
The Dixie Flatline (6/15/2011)
I'm shocked that I didn't have at least 1000 posts, but at least I'm still in the top 10. 😛
I think that is due to your...
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 15, 2011 at 4:13 pm
It reads to me that one server is Express and that the other is a server.
Either case, you should be able to get SSIS to work by installing from a...
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 15, 2011 at 3:52 pm
Log shipping
Or create an ssis export package that copies the data over to the secondary 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 15, 2011 at 3:32 pm
Steve Jones - SSC Editor (6/15/2011)
SQLRNNR - 2567
GilaMonster - 1957
Lynn Pettis - 1775
Alvin Ramard - 1745
Steve Jones - SSC Editor - 1434
Grant Fritchey -...
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 15, 2011 at 3:01 pm
Viewing 15 posts - 9,676 through 9,690 (of 19,560 total)