well, I'm not going to put "nolock" hint as I have heard that this hint might also throw some errors while a record in a table is being updated concurrently....

Any link to naming convention should help either... 🙂

Ok. I'm going with numeric as I see it was used at few places in my project. My only concern was I'm not sure which (numeric or decimal) would be...

"sp_change_users_login" procedure worked perfectly fine for me.

Thank you all.

gotcha. There are two XML connection string present in the installation folder in program files. One of them is for the main application & the other for an icon in...

I have the below message from the SQL Server Error Logs. And, I'm going to work with the application support to identity the reasons for these errors.

Date10/1/2008 2:04:09 PM

LogSQL Server...

I dont see any error numbers from the trace as this login works fine when I try to login from SSMS & also from the application. But, I dont know...

Thanks, Mike. I actually didn't know about linking the file from access to SQL Server. I have now few tips to bring a solution to our requirement.

For the last point,...

I had this message posted here because I'm working with an application which is highly normalized & have uniqueidentifier as the primary key in all tables. When this application tries...

Our application have 3 databases. Users name all these databases with their own name. As we are moving from present database version to newer database version we are sending all...

well! Each user has their own database & server. Not all users use common server.

Thanks. But, this is a one time script & this cannot be created as procedures or functions as this would be a script like patches given to different users to...

Jeff- This is a desktop application & I use the XML tag to carry the search items to be searched in the database. Like, a person's first, last name, phone,...

Thanks, Mahesh. But, ntext wont be supported as well in future SQL Server versions.

~Thanks

The issue I have is when I use this xp_cmdshell command from SQL Agent job it is failing when using UNC name. But, when I use the direct path (f:\test)...