Viewing 15 posts - 9,061 through 9,075 (of 9,725 total)
Check this link out and see if it helps:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2553214&SiteID=1
January 25, 2008 at 11:41 am
Given the staff changes issue, you need to start documenting what it is you're training the back up people on. Create a binder filled with details on what you...
January 25, 2008 at 11:31 am
If the group is really tight knit, you might want to consider your approach to them carefully. You don't want them to think you're trying to steal one of...
January 25, 2008 at 11:03 am
...or rather, they trust that I will have everything working right again quick enough that its only a minor issue...
And it's that comment that worries me. So you are...
January 25, 2008 at 10:52 am
The problem is that SQL Server Agent is not part of the client tools. It's part of the whole SQL Server Engine install. So taking off the client...
January 25, 2008 at 10:48 am
Check your Add/Remove Programs. SQL Express might have installed anyway when you installed VS 2005. If so, you'll need to uninstall it and reinstall the regular version of...
January 25, 2008 at 10:45 am
You might want to check DBCC InputBuffer in BOL and the text of SP_WHO to see if you can crib some code from the procedure to help you identify the...
January 25, 2008 at 8:35 am
Rolf,
I hope you didn't test this on a production machine...
Have you tried re-running the SQL 2000 install process to see if it gives you a repair option?
Look at...
January 25, 2008 at 8:29 am
Do you see the service pack 2 listed separately in Add/Remove Programs?
If so, try uninstalling that. If not, I'd call Microsoft. They should have a way of upgrading...
January 25, 2008 at 8:23 am
What version of SQL are you installing?
Have you previously installed Visual Studio 2005 and/or SQL Server Express on your box?
January 25, 2008 at 8:19 am
jwhite,
It's probably a global policy or local policy object that's grabbing this information. The Application Log audits stuff based on what the OS / Domain Security Policies are set...
January 25, 2008 at 8:18 am
Use Patindex() to locate your angle brackets. Then once you know those positions, you should be able to search between them with Substring() for the text you're looking for.
Check...
January 25, 2008 at 8:10 am
To see Line Numbers in SSMS, go to Tools -> Options -> Text Editor -> All Languages -> General and Plain Text -> General. To the right and near...
January 25, 2008 at 8:07 am
If these tables are that temporary, why are you even worried about what filegroup they end up on?
If it's a space or processing issue, here's another possibility. Create a...
January 25, 2008 at 8:00 am
SELECT INTO is much faster on FULL Recovery too. I've never profiled it to see if it works like TRUNCATE (minimally logged) or if it just works like Bulk...
January 25, 2008 at 7:58 am
Viewing 15 posts - 9,061 through 9,075 (of 9,725 total)