Hi all, I need to create a new database and not allow the user to delete the .mdf and .ldf files in the SQL server Data directory. How can I restrict the user from not deleting the physical files from the directory programmatically? Thanks ...more >>

I am having a problem with returning a string of values from the table, this will be part of a scalar function but here is where the code is jamming up. Code: DECLARE @string as nvarchar(200), @work nvarchar(200), @omBranchID int set @omBranchID = 11601 declare MyCursor CURSOR FOR SELE...more >>

I wrote an algorithm to get all the relatives of a person in a family tree. I'm basically getting all the users from the DB and am doing the recursive logic in code, so that there is only 1 call made to the DB. However, I am trying to do the same thing within a stored procedure in SQL using r...more >>

Hi All How Can I Restore Backup file With Password From Enterprise Manager Thanks ...more >>

Hi, I have a issue with updating a column in a larger table which has about 35 million records. what I need to do is select the NULL value for a particular column and populate it with a column value from the same table. something like update dbo.table1 set col1=col2 where col1 is null ...more >>

Hello: I'm getting the famous "Error converting data type varchar to numeric" error upon using an If, then statement. I'm not too familiar with the use of CAST or CONVERT, which I understand eliminates this sort of error. How do I use either of those terms in the following SELECT CASE s...more >>

hi, i got 2 tables called dvdinfo and actor. inside dvdinfo one can find i.e. titel, director, actorid1, actorid2, actorid3... inside actor i have added actorid and actor. actorid is thought as 1:n relationship to dvdinfo.actorid<x>. i know want to see an output as following: select ...more >>

how can i insert a row and increase the value of an integer field by one. there is no identity column and i cannot add one. i need to do something like, DECLARE @myvar varchar(8) SET @myvar = col1 +1 INSERT mytable VALUES ('@myvar', 'NULL', 'whatever') GO thanks.... col1 value would...more >>

I need help creating a while loop that inserts records into a temporary table this while should continue until all records matching column 3 have been added The insert above the while loop seeds the temporary table. Then the loop selects all distinct values from column 3 that do not exist in...more >>

Hello: I'm trying to complete an If, Then statement within a script that I put together, and I keep getting an "Incorrect syntax near the keyword 'As'" error toward the end of the statement. The whole statement says that if you are taking the payroll codes from the benefit table, then pr...more >>

I am facing a typical problem while connecting to SQLServer2005 on a remote machine. If my local machine is having the SQLServer2005, then i could able to connect to database and fetch result to my ASP.NET UI in a split second. If web application in my local machine trying get data from SQLServ...more >>

All, I am using SQL Server Manager Objects (SMO) Restore to restore an SQL Database. All works well however when I set the PercentCompleteNotification = 1 I would of expected the PercentCompleteEventHandler to trigger every one percent, instead it trigged a total 23 times, it should have...more >>

Hi all, I'm facing this Error in my application once in a while and once the app.jobs are re-run it might/might not finish successfully. The SP's are upto date. Any quick solution/ help is very much appreciated. ERROR: Input string was not in a correct format. at System.Text.StringBuild...more >>

Hi all, I need to perform a validation test on fields in stored data for each row and updating the Comment field with the reasons why test failed where appropriate. The real scenario has quite a number of fields for me to use a CASE also I want to avoid using a looping mechanism to build the...more >>