I have typical problem going with Sql server 2000. "SA" password changes automatically for every two or three weeks . I am not sure what exactly...
Thank you all for suggestions. I think "EXEC('USE '+@DBName+' Select cols from tableName')" will work for my case. I will try this today. Coming...
I have a system which has one centralised database for all the locations and one database for each service in each location and luckily database...
I have a database column in Sql server of type "ntext" which stores XML data. I need to fetch data from this column using asp.net and display...
Separate names with a comma.