Well as of now I'm trying to create a UDF doing exactly what one of the sub-procs are doing to avoid one level of nesting. I'm hoping against the...
Hi All, While trying to develop an online reporting panel I'm stuck on a problem I'm unable to find an answer on my own. Hence, the request for you...
Hi Friends, While testing a few techniques to reclaim OS space I deleted all of my tables except the 3 biggest of them all. I truncated these 3...
Hi, My Server Config. is Quadcore Dual Processor with 16GB RAM. DB size is 17GB & We have seperately assigned 13GB of RAM dedicated to SQL Server. I...
I have a nonclustered, unique, primary key located on PRIMARY ID May I also add that this is already an archive table. whereby everday last day's...
Hi, I've a table with about 15,379,759 records in the past six months. I only maintain a data of about last six months in this table & move earlier...
Hi, I've been noticing that while taking a snapshot backup in MSSQL 2000 the time taken to backup the database completes in around 10-12 minutes for...
Hi Everbody, I just changed the Computer Name (From Windows Properties) back to its older name (This name I got to know of when I contacted an...
Yes hemant, I did changed the name physically in SQL Service Manager - Computer Name. But as I told in an earlier reply. sp_helpserver is not...
HI, I just trie out the solution you provided. While at one instance while selecting the user it did looked like the problem may just get resolved....
Hi, I tried running sp_dropserver & as a result of which I got the following message. "The server 'OldDbadministrator' does not exist. Use...
That's exactly the question. How to change? SQL Server won't allow us to delete dbo user. So in that case we need to modify it somehow. But how do we...
Hi jaybee, I just now tried out the command you supplied. Here's the syntax I used & the message returned to me. exec sp_changedbowner @loginame =...
Hi Satya, That's not the problem. Though for the records I already did that. The issue is not with DB Connectivity w.r.t users & their logins. But...
Hi, I want to know the process to change the Database Owner name. While I have changed the Server Name in SQL Server Service Manager, Computer Name...
Separate names with a comma.
