Viewing 15 posts - 91 through 105 (of 659 total)
I am trying to change local account to windows account as service ac for sql server but when i change login as from services>SQL Server Service > properties its net...
March 2, 2009 at 1:07 pm
Yes, I am doing partion now in my new stuff apart from that i still want to improve my t-sql to insert records very effeceintly and very fast.
Thanks
February 27, 2009 at 1:43 pm
I am not sure what is going on with my updates. ITs been 20 hrs still the status is in suspending mode, i think itsd not good but my updatres...
February 27, 2009 at 5:24 am
since my job was running for very long and i didnt see any status when i checked " view history" i forced job to stop and i ran the t-sql...
February 26, 2009 at 7:28 pm
I was able to check for the owners and change ownership, now i am deleting the login from the server, but deleting it from the server may not delete on...
February 26, 2009 at 11:48 am
But my doubt is , what is the difference between " VIEW DEFINITION" on server and database. I was expecting that if i grant view definition on the server...
February 26, 2009 at 8:53 am
How can i pull out if the user has owned any obejcts,scemas etc.. as i am deleting the user so that wanna make sure i change the ownership of those...
February 24, 2009 at 11:27 am
I dont see that file name to any of the existing databases on the server.
February 24, 2009 at 11:19 am
I understand what you say... but is there a way in t-sql to list all databases where physical file names are not matching with the database name or vise versa...
February 24, 2009 at 9:54 am
I checked again, there is no other SQL server running and the drive is also not shared, what else i can check.
I also tried attaching that file to the server...
February 24, 2009 at 9:10 am
I still cant figure out how would i determine which process is using the mdf files though the database is not existing.
Also how can i find if there any other...
February 24, 2009 at 8:11 am
If my sql server is running under local account without any windows service account can i be still able to backup databaase over network drive?
is there any work around...
February 20, 2009 at 11:17 am
If i cant use those procs then i may have to do regular maintanance plan as i dont have litespeed liscences anymore.
If my sql server is running under local account...
February 20, 2009 at 8:59 am
Do you think if i migrate those it will not work??
February 20, 2009 at 8:20 am
Viewing 15 posts - 91 through 105 (of 659 total)