Viewing 15 posts - 3,796 through 3,810 (of 7,191 total)
When you run it in Visual Studio, it runs as you. When it runs as a job, it runs as the SQL Server service account, or whatever proxy is...
October 10, 2013 at 7:24 am
Try it for yourself. Create a new login with the restricted permissions and log on as it. See what you can see and see what you can do....
October 10, 2013 at 5:16 am
Add a WHERE clause. And your STUFF function can be simplified. Since it's always the first character you're changing, and you always change it to M, the...
October 10, 2013 at 4:59 am
You need to use the STUFF function. Have a go at writing the UPDATE query, and post back if there's anything in particular that you don't understand.
John
October 10, 2013 at 4:45 am
No, it will have been under something like Development Tools. It'll be documented somewhere.
John
October 9, 2013 at 9:03 am
But you upgraded to SSMS R2 using the installation DVD, right? You should be able to install Visual Studio (BIDS) from there.
John
October 9, 2013 at 8:49 am
Are the packages stored in msdb or in the file system? Have you tried opening them with Visual Studio 2008?
John
October 9, 2013 at 8:36 am
Granting SELECT on a view does exactly that. It doesn't revoke any other permissions that the user already has. Query sys.database_permissions to find out what those permissions are.
John
October 9, 2013 at 2:57 am
Luis Cazares (10/8/2013)
What about normalizing data?
Absolutely. If you have any control over the structure of the table, you should remove the CountryId and StateId columns, since they are attributes...
October 9, 2013 at 2:36 am
If you don't have much experience of tuning queries, then I would advise you to seek advice from someone does. You'll need to pay for that if you don't...
October 9, 2013 at 1:32 am
David.Poole (10/7/2013)
Jeff Moden (10/5/2013)
Heh... you have to trust me on this... You DON'T actually want them to do their own backups. 😉
Backups fine, restores...not so much
I don't...
October 7, 2013 at 2:24 am
...
AND membercode IN (@membercode)
AND PubCode IN (@Source)
...
John
October 4, 2013 at 8:53 am
You should be able to use the actual name as well as the alias (or even the IP address).
John
October 4, 2013 at 5:45 am
Two DBAs to about 19 developers. And they insist we handle stuff like backups and restores on development servers for them, "because the DBAs have always done that for...
October 4, 2013 at 5:42 am
Yes, good idea. Still susceptible to locks, but at least the file's safe once it's done. You can actually do it as part of your SSIS package without...
October 3, 2013 at 8:10 am
Viewing 15 posts - 3,796 through 3,810 (of 7,191 total)