Viewing 15 posts - 3,796 through 3,810 (of 7,187 total)
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
Permanently running, but does it actually hold a lock on the file permanently? That's what you need to check. If you double-click on the file and it opens,...
October 2, 2013 at 2:48 am
Definitely, which is why I suggested the retries on the job. Do you have any figures on how long the application takes to transfer the data into the CSV...
October 2, 2013 at 2:23 am
Sounds like you attempted the import at the very moment the CSV file was being written to by the third-party program. Try creating an SSIS package and running it...
October 2, 2013 at 2:01 am
Another way to do it is to create a RehireCode table with (1,A), (2,B), ... , (27,AA), (28, AB), ... and join to that.
27 is an awful lot of times...
September 30, 2013 at 8:34 am
Viewing 15 posts - 3,796 through 3,810 (of 7,187 total)