Viewing 15 posts - 30,106 through 30,120 (of 39,819 total)
Is this an OS scheduled task? I'm sure there is, but it involves giving your privileges on the web that you might not want to do.
What I'd suggest is that...
December 31, 2007 at 10:50 am
Also be sure if you have a package or something that you're not waiting for user input. If you are, you're stuck.
December 31, 2007 at 10:44 am
Can you add some logging to the steps, to be sure it's completed? Maybe an insert into a table as the last part of a proc or package?
December 31, 2007 at 10:44 am
5 if on XP home, 10 on W2K Pro or XP Pro. OS limitations, not Express (http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx).
December 31, 2007 at 10:43 am
I mentioned it, but Roy's post made me think about it again. Be sure you argue for a development/test system that's the same size. Becomes really hard to work on...
December 31, 2007 at 10:41 am
I tend to agree with Wayne. While a good general knowledge of all parts of systems (all parts of SQL as well as windows, etc.), is good, if there's something...
December 31, 2007 at 10:32 am
Sorry about the links. Not sure what's wrong, but I'll see if I can track it down.
December 31, 2007 at 10:26 am
There are lots of stored procs in AdventureWorks. I know some authors use it as well on this site:
http://www.sqlservercentral.com/articles/Administration/2771/
http://www.sqlservercentral.com/articles/Product+Reviews/3050/
December 30, 2007 at 5:28 pm
Active threads does show all threads receiving a post since your last login. It doesn't show just what you participated in.
The "Recent Posts" above has a few other options.
December 30, 2007 at 11:44 am
Gail is correct, you need to query every table with a GUID. And every column.
Use Jeff's query to find the tables/columns and then query each of those.
December 30, 2007 at 11:21 am
Apologies, looks like they've been moved to Codeplex (http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en).
Check permissions on that file. Be sure that the SQL Server service can access it. There could be permissions on that particular...
December 30, 2007 at 11:20 am
SQL Slammer used 1434 and it can be a problem. This port is used to discover other SQL Server instances and is a pain if it's not open, but you...
December 30, 2007 at 11:17 am
The DMV for plans shows what's in cached, but that doesn't tell you what's been run recently. If you had lots of different procs run, you might see them getting...
December 30, 2007 at 11:16 am
I don't know that there's a good collection anywhere that you can reference. Lots of blogs and short notes/articles around. Search "VLDB SQL Server".
You will probably have to consider filegroups...
December 30, 2007 at 11:14 am
Question has been changed to say 2005. Thanks for the comments.
December 30, 2007 at 11:12 am
Viewing 15 posts - 30,106 through 30,120 (of 39,819 total)