Viewing 6 posts - 1 through 6 (of 6 total)
Hi Chad Miller
Thanks for providing the script. i would like to know whether this script work for 2005/2008 or do you have different script ?
Basically i am trying to find...
March 5, 2014 at 10:42 pm
#1694541
hi
dbcreator have only permission to create new database on the instance, if you want alter the database to add the file, u need db_owner of alter database permission on...
November 22, 2011 at 5:03 am
#1411357
Hi
if sql server agent is not able to connect sql server database engine, we will get this error
Kindly check what service account sql server agent service is running , whether...
March 23, 2011 at 5:23 am
#1302393
Hi SQL DBA
I am also working from sql 2000 version... i have around 5+ years experience in SQL Server DBA and around 2+ years exp in DB2 DBA.
According my experience,...
March 23, 2011 at 1:11 am
#1302297
Kindly find the sample code...hope this will help u...is there any better way of performing the delete operation, kindly let us know
Declare @count int
set @count =0
while @count<=2000
begin
delete from tablename...
March 23, 2011 at 12:52 am
#1302292
Please provide more information about your server as well as sql server memory configuration
1 )What is memory configuration in boot.ini file (swtich used related to memory usage like /PAE...
March 22, 2011 at 6:18 am
#1301823