Viewing 15 posts - 9,091 through 9,105 (of 9,725 total)
Verify via the SQL Server Surface Area Configuration Tool that you have xp_cmdshell enabled on this server. Usually when something takes that long before returning an error, it's stuck...
January 24, 2008 at 4:28 am
You can't downgrade a DB to SQL 2000, but you can script out all the objects, recreate them in SQL 2000, move some of the data (top 1000 or 5000...
January 24, 2008 at 4:24 am
I can't give you actual monitoring scripts because I didn't write some of them and I don't have permissions to hand the ones I didn't create. Also, you can...
January 24, 2008 at 4:22 am
BOL also has some good tutorials. And if you don't have access to SQL Server at the moment, you can either download the eval version of 2k5 or (recommended)...
January 24, 2008 at 3:59 am
And save all your T-SQL scripts! You'd be amazed at how handy that comes in 6 months down the road when you need to replicate that "one time" job.
January 23, 2008 at 11:25 am
Dennis,
The best way to see what SQL process are using up the memory is go into System Monitor and choose the regular OS memory counters as well as whatever SQL...
January 23, 2008 at 7:58 am
You should also check out the Certification Forum on this site to see what other people have posted about these exams.
January 23, 2008 at 5:49 am
I've done it where I've had multiple data sources in the report, then just edited the DataSets right after Testing so that it pointed to the proper data source when...
January 23, 2008 at 5:44 am
SQL 2k5 has a whole bunch of new system catalog views that help you identify unused indexes, etc. Check out "sys.dm_db_index" in BOL. This will get you to the...
January 23, 2008 at 5:40 am
I started reading the Self Paced training kit for 70-441 (one of the Dev exams) and found that it discusses some of the BI stuff at an "introductory" level. ...
January 23, 2008 at 5:28 am
Ideally the powerful userids are saved in a sealed envelope...in your bosses desk.
Ummm, forgive me for disagreeing with that statement, but I've seen too many stuff stolen by other coworkers...
January 22, 2008 at 5:51 am
I'm glad you finally got it working.
Mis-Aligned Height settings can also mess you up. So if you haven't checked that already, you should.
January 22, 2008 at 4:09 am
Visual Studio should always be installed BEFORE SQL Server or you'll mess up the install. We had major problems at my workplace when we did it reversed.
On the other...
January 21, 2008 at 10:32 am
That's okay. We forgive you.
Only as long as your misconduct was illegal and entertaining that is. @=)
January 21, 2008 at 10:29 am
Notifications come from a different email address than the newsletters. I've never had a problem receiving them or having them caught by the spam filter.
January 21, 2008 at 7:32 am
Viewing 15 posts - 9,091 through 9,105 (of 9,725 total)