There are about 35 jobs.. all kinds of jobs are there.. perging, maintenance jobs..data moving jobs..and its all running without error..how i make...
sorry for the delay.. i was not able to access for some days which job folder you are telling? OS job folder? no i did not check, what i have to...
Hi all, I am facing an issue on sql server 2000 with sql agent job history. below are the details Box- Windows 200 server Sql server 2000 with...
Thanks Satya, i did not do till now because, i was waiting for the confirmation from an expert.. thanks for the advice. if there any link explains...
Hi all, I have an 2 node active/passive cluster on windows 2003 R2 on sqlserver 2000. My storage is MSA500 g2 now i have added 2 more array tothe...
Thanks for your response, In the above case the db will created, even with GUI we can create db no probs in that.. now the issue comes when you set...
He has already access to the server storage, when i tried with default model db he can create..no issue on that.. this happened when i set size and...
Dear all, I am facing an issue i have a user with dbcreator server role. My server i have set a size and some other setting on model db. Now this...
Thanks a lot Elisabeth, Now its clear for me, is there any way i can know the space used by each index in table. (not by sp_spaceused 'table name')...
Thanks Elisabeth for your prompt reply, below are the details I understood correct me if am wrong. Heap table – is a table with no clustered...
Dear Elisabeth, Thanks a lot for the reply, but still I have some doubts. Let me start with clustered index:- Does clustered index has a separate...
you can't install SQL 2005 EE on Vista, please check the below link http://technet.microsoft.com/en-us/library/ms143506(SQL.90).aspx Thanks John
How can a page split occur on non-clustered index, this will only happen with clustered index as its physically sorted. so why pad_index is allowed...
I don't know i am correct or not.. but you edit the host file and add different name to the same IP eg: 192.168.1.1 sqlserver1, 192.168.1.1...
you have to create a dynamic sql after concatination of both the variables select @x='dbo', @y='okk' select @sqlstr='select * from '+@x+'.'+@y You...
Hi Richard, The error message is clear, there should not be any active connection on the database when you issue an alter database command. There...
one question, may am thinking wrong... can we create back schedules as full and tran even the db is in logshipping. do we really require to do this?...
hope this can help you.. select sdb.name,loginame,login_time,hostname,program_name from sysprocesses sp (nolock) inner join sysdatabases sdb(nolock)...
Thanks Adriann, This is the problem i was facing..the out put from the derived table is not 'NULL' its just nothing, so the outer table with isnull...
Dear Adriaan, Thanks for the reply.. i was trying to say a situtions which i am facing now..that example is just to explan what i want.. let me tell...
Separate names with a comma.
