Forum: Microsoft SQL / MS SQL Server

DECLARE @PhotoID int DECLARE photo_cursor CURSOR FOR SELECT PhotoID FROM Photos OPEN photo_cursor FETCH NEXT FROM photo_cursor WHILE...

Handoyo, This is nothing to do with the 2k vs xp. It is more likely due to your changing the password of the account that SQL server is set to...

Thanks, i thought that was the case... just wanted to confirm it before i started working on it. Alex "Vishal Parkar" <vgparkar@hotmail.com>...

Bulk insert itself is working. But if it was your first time encountering example not working of simply the wrong answer in one of those...

I have a problem with people logging on as one user, but sql server keeps changing the owner to dbo. Sometimes the owner name will be their loggin...

Whoops. You can possibly undo the transaction using Log Explorer (www.lumigent.com). Don't think you can restore just a table from a backup file,...

Thank You for the quick response. I did log into our server as the proxy account and I can run the following command successfully: However,...

Lets say I have a privilege structure organized by number: 1 - Administrator 2 - Office 3 - Supervisor 4 - Field Operator 5 - Assistant...

When new data come in, it may be a brand new record, or an update of old record. So, I have to check the data, and choose either INSERT or UPDATE. ...

I have 3 integer columns in my table, which represents the date of entry: dayEntry monthEntry yearEntry How can I combine this 3 columns to...

I know that there is a routine that will return the four components of a fully qualified name but I can't locate the name of that routine. I...

Thanks for the help guys. CELKO, sorry if all that was elementary. I'm new to this. Like I mentioned this was imported from Access so I didn't...

Hi Freinds, I need to copy a file from: \\serverone\folder\myfile.txt to \\servertwo\folder\myfile.txt where \\servertwo is my sql server and...

hi folks, I have accidentally UPDATEed huge amount of data that is in a table. I need to rollback it....is there any way to do it using log file...

Could anybody please answer me on this query: SELECT * FROM DBName..TableName where CONVERT(DATETIME,(CONVERT(CHAR(8),((CONVERT...

>> Want to create DB for cars and models, but not really familiar with what the data should be. << Start doing research. Look up what the VIN...

Anyone have any ideas why this doesn't return any values? This is an SP that was constructed from a Query in an Access database that was imported...

Hello, if I do an INSERT INTO based on a SELECT with an ORDER BY can I be 100% sure that the records entered will have an incremental key on the...

We have a client with 2 connected SQL servers, development & production. I am having a problem using DTS to move objects between the 2. If I use...

Hi, Since my db upgrade from SQL 7 to SQL 2000, one of my MTS objects fails with the error: "0x80004005 Microsoft Cursor Engine - Insufficient...