Guys, i have used index tuning wizard in SQL 2000 a couple of times. as i remember i recommends us on a table where should we create a index. i need to do it...
Hi All, I am having server A in Location A,Server B in Location B.Bothare in Windows server 2003,SQl Server 2000.Both servers are having same DataBase named...
Hi I have a table in 2005 and has to be migrated to 2000. Using Import/Export wizard in 2005 the migration is done and found a Trigger, Default values on...
Hi SqlCon Members, i have created procedure as below. create proc proc1 as begin select * from emp --dbcc inputbuffer(@@spid) end go exec Proc1 go i need to...
I Need to update sysdatabases. But i am unable to update it as error "Ad hoc updates to system catalogs are not allowed." Then I tried to execute: USE MASTER ...
hi, can anybody help me on this topic I have a mySQL query like the following:SELECT wo.CREATEDTIME FROM woThe result is supposed to be a list of date in a...
Hi I have a db with 300+ tables working fine. Now the client wants to include AUDIT on some tables only on specific columns. An UPDATE trigger on the selected...
Folks, I need guidance from you guys. I have to come up with a script which can automate the following things:- We have 2 servers, "A" and "B" and both have...
Dear to all, we are using MS SQL Server 2000 . My database transaction log files is too large. I woul like to be clear the log file. If any one suggest me how...
Hi All, I am assigned to migrated oracle database to sqlserver2005 database. so can you mail how to start and complete this task and migration mainly to...
Hi All, I wrote a small procedure in sql server 2005. when i pass the wrong parameters to the parameters am getting error. How can we trap the prarameter...
Hi All i need your help like why this is happening.. Having an INSERT trigger on a table when tried to insert some 10 rows at once, the trigger fires only on...
Tired of mundane backup-and-restore legacy SQL Server work? Looking for more interesting challenges in database design & SQL Server 2005? Our client moves 12...
Dear all, I have lock on db, how to release it?? i have issued on dbreindex on a table and it went for long so i kill the process. now it says killed.. but the...
1. MICROSOFT DOES NOT SUPPORT SQL SERVER running any other non-Microsoft Virtualization Software: Microsoft does not test or support Microsoft software running...
Required SQL Server DBAs for a CMMi5 company in Mumbai. Hi, We have immediate requirements for SQL Server DBAs with our CMMi Level5 client in Mumbai. ...
Can anybody help me in this.. i want to add i feild in the cusor variable.. while (@@Fetch_status = 0) Begin Print 'ID '+ convert(varchar,@msg1) +' and Ref= '...
Hi, I have 2 systems , 1 system has XP professional with sql server 2005 and another system has Windows server 2003 server with sql server 2000. Both the...
Hi All, If Master Database Dropped Accedentally then Will SQL SERVER Work??? if it "No" then What may be solution For This.... With Regards S.Santosh...
Hi, Assume i am having a table with salary details just i want to find out all salaries what i have in 7th to 15 th row.. Is it Possible by writing a...
hi all, i had a view in my project, i am inserting a record in to that view (View contains a identity key for a column), with in stored procedure i am...
Hi Team, Primary server dts jobs are replicated successfully to secondary server through a third party tool. Here the primary server is under domain account....
Guys, What is the best way for DR. Please let me know in details. Thanks in advance.... Nitin Get the freedom to save as many mails as you wish. To know how,...
FYI: Plan to attend these webcasts by Microsoft SQL experts....! Webcast Schedule - October 2007 Attend a series of LIVE Webcasts this October by Microsoft...
I want to restore a database from sql server 2k to sql server 2k5 . Its getting restored and also process its showing in percentages at last its showing unable...
<http://cl.exct.net/open.aspx?ffcb10-fe64157375650d7e7d16-fe011174776505 7e71117276-fef8157771670c-fe92157877660d7b74-fdfa157277600c797513707c-ff cf14> To view...
