We have SQL Server 2005, and an outside consultant created views as a 'GOD' login. Now other logins can see the view, but no data is returned. The 'GOD' login returns data from the same views. Other logins can see the data from the underlying tables for the views. Consultant is no longer...

We've been having an issue where disk time suddenly starts to get pegged at 1000+%. It stays like that indefinitely until we restart sql server. Normally disk time sticks between 0-10% for a day or so before this happens and it never seems to happen at any certain time of the day. The server was...

Hi, I have 2 tables. TPerson(PersonID, ...) and TPersonRelation(PersonRelationID, Person1ID (FK1), Person2ID(FK2), TypeOfRelationID). All fields are integers. The relations are the follow: PersonID --> Person1ID and the same PK Fields PersonID --> Person2ID. How can I implement both relations,...

Hi Guys. I have 2 tables. TPerson(PersonID, ...) and TPersonRelation(PersonRelationID, Person1ID (FK1), Person2ID(FK2), TypeOfRelationID). All fields are integers. The relations are the follow: PersonID --> Person1ID and the same PK Fields PersonID --> Person2ID. How can I implement both relations...

I am curious as if to you got any more information regarding this issue. I have a SQL2005 hpEVA install coming up and I have been scouring the internet for information regarding Data,log,tempdb placement in light of the vdisk,diskgroup dynamic that occurs in these virtual arrays. Essentially since I...

I have a SQL Server 2005 active/passive cluster which has the quorum drive on a partitioned SAN LUN. I want to fix this and get the quorum drive on its own dedicated SAN LUN. What is the best way to move the quorum from the old LUN to the new LUN? Thanks in advance.

I have imported several tables from Access into ms sql server 2005 and was wondering what datatype to use for my large text fields. Is varchar(max) the correct choice? I'm importing some very large blocks of data. No images, but lots of html. Thanks.

Hi All, I have Database with 500 tables intially, now i have separated 500 tables in to two different databases.these two databases has been configured for log shipping process.now i am planing to Shinking the intial database to release the unused space.in this case is my logshipping process will distrub...

HI All, Here i am planing to ask one security related issue in SQL Server 2005: I have created one Login id with dbo permissions. After few days the dbo permissions has been changed to readear by some of our team members. How can i able to track who has changed the permissions for that particular Id...

Hi, I am writing a stored procedure and want to copy some specific columns into another table. Here is the Code, it gives an error. Fields in table(interview): endclient, canid, timezone, interviewdate_5thrnd My Code: CREATE Procedure chkinterview AS BEGIN declare @curdt datetime, @dtadd datetime select...