Viewing 15 posts - 2,701 through 2,715 (of 6,105 total)
Do you know what Network Libraries the server is listening on? Is it a full-blown SQL Server or an MSDE install?
Also, you can tell the instance name by examining the...
November 26, 2005 at 5:54 am
#1 is much, much easier than #2. #2 there are some articles on, but the term "DBA" now is used for a rather broad set of duties. For instance, in...
November 26, 2005 at 5:48 am
If it's adding logins to SQL Server, you'll actually need one additional permission.
Ability to add logins to SQL Server: securityadmin fixed server role.
BTW, the securityadmin fixed server role does have...
November 26, 2005 at 5:34 am
Where is this SQL Server located in relation to you? Is it on an internal network with you or are you connecting over the Internet? Also where is your ASP.Net...
November 26, 2005 at 5:27 am
And both are failing to register or is it just the one on the AD DC?
November 20, 2005 at 7:00 pm
Well, @param1 should probably be param1 without the @, but other than that, unless the database has case sensitivity, that follows the basic values. I think I used adParamOutput but...
November 20, 2005 at 6:58 pm
What is @param1? Did you mean param1?
Also, what happens if you execute the stored procedure in T-SQL with an OUTPUT parameter say through QA? Do you get a value back?
November 20, 2005 at 2:04 pm
It looks like the file was corrupted then, the main one (the .mdf). based on:
2005-11-20 13:37:10.09 spid10 The header for file 'C:\Program Files\Microsoft SQL Server\MSSQL\data\62NOSP1_Data.MDF' is not...
November 20, 2005 at 1:12 pm
You'll want to take a look at the following in order to get the databases/security principals moved successfully.
November 20, 2005 at 11:40 am
When you look at the local security policy, say a few hours after you make your change, has it reverted back? In other words, the SQL Server account no longer...
November 20, 2005 at 11:37 am
Speaking from a SAN/Cluster Administrator perspective, you still have to do the proper planning and deployment with respect to supporting databases, whether they be SQL Server or Exchange. A lot...
November 20, 2005 at 11:36 am
It sounds like there may be corruption in the files or files are missing. Are you sure you were able to recover all the files (include any .ldf and .ndf...
November 20, 2005 at 11:28 am
The application works by putting osql into a loop. If it detects blocking it dumps it to a file... I suppose you could modify it to send an email, but...
November 20, 2005 at 11:18 am
MSSQLServerADHelper only runs when SQL Server needs it to. It doesn't run all the time.
As far as the name... If you run from a command prompt ipconfig /all you'll get...
November 20, 2005 at 11:17 am
Microsoft's PSS usually directs you here:
How to monitor SQL Server 2000 blocking (271509)
There is a new tool, called Sherlock, which takes the information from the sp_blocker_pss80...
November 19, 2005 at 7:57 pm
Viewing 15 posts - 2,701 through 2,715 (of 6,105 total)