Viewing 15 posts - 6,106 through 6,120 (of 19,560 total)
Here's the Syntax
sp_addlogin [ @loginame = ] 'login'
[ , [ @passwd = ] 'password' ]
[ , [ @defdb = ]...
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 27, 2012 at 11:43 am
Sqlism (6/27/2012)
Please suggest me what are the configurations and pre requisites required to set up a job that runs SSIS package.
Issue: Pulling data from prod box to dev box....
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 27, 2012 at 11:24 am
I'd recommend using the code that you listed instead.
sp_addlogin is being deprecated.
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 27, 2012 at 11:21 am
Steve Jones - SSC Editor (6/27/2012)
Revenant (6/27/2012)
Steve, that has already happened. 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 27, 2012 at 11:16 am
A note: If you are running in compat 80 on a SQL 2008 R2 Enterprise instance, you can still use compression for your tables, views (indexed views), and indexes.
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
June 27, 2012 at 11:12 am
Create view requires Alter permission on the schema. With alter on the schema, the user would then be able to alter other objects within that schema.
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 27, 2012 at 11:05 am
Cliff Jones (6/27/2012)
Lynn Pettis (6/26/2012)
SmokyColorado Springs!
Box Springs
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 27, 2012 at 10:33 am
Perry Whittle (6/27/2012)
SQLRNNR (6/27/2012)
The image won't come up for me.it should open in a new window, alternatively the car is pictured here 😉
Thanks - opening the pic gave a "double...
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 27, 2012 at 10:31 am
You can run it from another server. When creating the SQL Agent job, specify the source of the package (for instance you can select the production SQL server if...
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 27, 2012 at 9:26 am
Sean Lange (6/27/2012)
I had someone tell me that the WITH (NOLOCK) was their company standard.:w00t:
Did you start launching pork chops at them immediately? Somebody really needs to educate that company...
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 27, 2012 at 9:24 am
What is the definition of that table?
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 27, 2012 at 9:22 am
The image won't come up for me.
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 27, 2012 at 9:21 am
If you backup to a new backup device or new file, do you still get 130GB in the backup file?
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 27, 2012 at 9:21 am
Thanks Hugo.
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 27, 2012 at 9:13 am
Yes, bouncing the service will resolve it. If scripting the shrink did not resolve it, it may depend on the script. But you are possibly down 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
June 26, 2012 at 11:08 am
Viewing 15 posts - 6,106 through 6,120 (of 19,560 total)