Viewing 15 posts - 91 through 105 (of 1,252 total)
Thats a lot of usefull info Gail.. thanks
November 18, 2009 at 5:17 am
Thats a inspiring story. Keep going Josef.
November 17, 2009 at 12:30 am
I think the user is using osql to run the script from a diff machine. If so r u able to connect to your db server from the machine you...
November 16, 2009 at 10:53 pm
Yup.. depending on the company the roles of development and production dba might overlap.
November 16, 2009 at 2:40 am
Are those processes related to SQL server or some other processes.
November 16, 2009 at 2:35 am
Check out BOL for sqlcmd or osql utility.
How ever you need to have a sysadmin privileges to add others to sysadmin role.
Edit:- Please be sure of the users you...
November 16, 2009 at 2:32 am
hmm... did'nt kknow about rollback after. thanks
November 16, 2009 at 2:26 am
SA pwd should never be given to all the users. Its a bad practice. You can create a application role and manage user permissions as the previous post suggested...
November 12, 2009 at 5:00 am
I have written a script which checks whether sql agent is running and then starts sql agent if its not. You can also do the same using SP_Configure and the...
November 12, 2009 at 4:37 am
Interesting but i feel its not practical to add dummy columns to tables. 🙂
November 5, 2009 at 2:59 am
yes i believe. check out BOL - Features Supported by the Editions of SQL Server 2008 .
November 2, 2009 at 1:20 am
However, When i take the stored procedure and run it from an SSMS query window, I get the full lenght of the fields every time.
Was the length of the imported...
October 29, 2009 at 6:03 am
Viewing 15 posts - 91 through 105 (of 1,252 total)