Viewing 15 posts - 4,021 through 4,035 (of 6,105 total)
I guess in college I marched to the beat of a different drum. (pun intended - I was at The Citadel in Regimental Band) While there I was band librarian...
September 8, 2003 at 11:14 am
Textpad. (Seriously)
Other than that I stay in QA mostly. I type faster than I can click a mouse (but I won't be breaking any speed records with either), so text-based...
September 8, 2003 at 11:09 am
quote:
Are you sure you want to go there? This thread could turn into a mile long
September 8, 2003 at 11:07 am
quote:
now , this is the second true suprise.29 ? Must be monday morning, that I feel old again
September 8, 2003 at 8:57 am
Does this happen every time or did it start recently? When you go to the server, are you able to start up Outlook and send and receive mail normally?
K. Brian...
September 6, 2003 at 5:13 pm
If he's having to audit a text field, the the INSTEAD OF trigger is necessary, unfortunately. The AFTER trigger doesn't allow references to text, ntext, and image columns but the...
September 6, 2003 at 5:09 pm
Taking a wild stab in the dark. Do you see anything other than these two files in the sysfiles and sysfiles1 tables for that particular database?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to...
September 5, 2003 at 2:27 pm
I would be extremely leary with this interpretation based on comments I've seen in other forums. You may have limited the # of processors the OS sees, but it is...
September 5, 2003 at 2:14 pm
You can perform the update within the INSTEAD OF trigger itself. So long as you don't have recursive triggers turned on. See the example in Books Online for INSTEAD OF...
September 5, 2003 at 2:06 pm
Do you have more than one log file? An sp_helpdb command will reveal what files are present. Look in the usage column.
For instance:
EXEC sp_helpdb 'Northwind'
will reveal two files:
Northwind (data only)
Northwind_log...
September 5, 2003 at 1:54 pm
From Microsoft's Licensing Whitepaper:
quote:
SQL Server 2000 includes a multi-instancing feature which allows customers to install SQL Server more than once on a...
September 5, 2003 at 1:41 pm
Try:
SELECT is_srvrolemember('sysadmin')
A sysadmin account should return with a 1.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
September 5, 2003 at 1:35 pm
Not seen it myself. Even if you do a check on the server role within T-SQL, a sysadmin role user will return as a serveradmin role user. Some undocumented bug?
K....
September 5, 2003 at 12:56 pm
From a command prompt, you can run a netstat -an and see if 1433 is still being used. It's not an IP conflict so much as a port conflict. Something...
September 5, 2003 at 9:41 am
How fast does the query run say through QA?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
September 5, 2003 at 9:33 am
Viewing 15 posts - 4,021 through 4,035 (of 6,105 total)