Here's the Syntax

sp_addlogin [ @loginame = ] 'login'

[ , [ @passwd = ] 'password' ]

[ , [ @defdb = ]...

Sqlism (6/27/2012)

---

Hello all

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....

I'd recommend using the code that you listed instead.

sp_addlogin is being deprecated.

Steve Jones - SSC Editor (6/27/2012)

---

Revenant (6/27/2012)

---

"New releases of products will likely come in the cloud first, and in a version you can buy second."

Steve, that has already happened. You...

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...

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.

Box Springs

Thanks - opening the pic gave a "double...

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...

Sean Lange (6/27/2012)

---

Did you start launching pork chops at them immediately? Somebody really needs to educate that company...

What is the definition of that table?

The image won't come up for me.

If you backup to a new backup device or new file, do you still get 130GB in the backup file?

Thanks Hugo.

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...