Viewing 15 posts - 27,931 through 27,945 (of 39,769 total)
A couple of things.
Be sure the remote connection is using TCP/IP on both sides. It must be enabled on the server and set to be used on the client.
Also, if...
July 7, 2008 at 10:19 am
All the files are at the bottom of the article. I didn't notice the links internally, which needed to be removed.
July 7, 2008 at 10:14 am
The buffer pool.
You might want to read up here: http://msdn.microsoft.com/en-us/library/ms187499.aspx
July 7, 2008 at 9:14 am
And those cars aren't perfect. There are "features" on them that don't work. Browse the recall lists and you might be surprised how many things need to be fixed. If...
July 7, 2008 at 9:12 am
No hidden files. MDF + NDF(s) + LDF is the database size. Don't forget backups.
July 7, 2008 at 9:11 am
It is interesting and the title doesn't help. It's a good thing that so many people want to help, and I can sympathize. Reading 50+ replies is time consuming.
Everyone wants...
July 7, 2008 at 9:10 am
usually. Rebuild indexes to defragment. Shrinking usually causes fragmentation.
July 7, 2008 at 9:09 am
Assemblies can be flaky if they're 32bit, SQLMail doesn't work, etc. There are potential issues, but if you have a simple db setup, then you should be OK.
July 7, 2008 at 8:58 am
The DBA architect is fairly specialized, and I'm not sure how valuable it is.
I'd stick with ITPro as the certification to show off and use on your resume/CV
July 7, 2008 at 8:57 am
You could use a union and select a field
if exists ( select ID from sysobjects where ...
...
July 7, 2008 at 8:56 am
You need to call Microsoft for this. Catalog errors can have serious effects on your database.
July 7, 2008 at 8:54 am
We have this on our list, not sure if this is something we want to do, or how well it would be used.
All topics have icons to mark about if...
July 7, 2008 at 8:50 am
You'd have to check on the various publications and amount of changes.
I've seen 100MB databases have 1GB worth of changes a month. Replication moves all changes, so if someone does...
July 7, 2008 at 8:48 am
I'd recommend backup/restore OR make sure you have a copy of the files before attaching. The upgrade is a one way process, so you cannot go back to SQL 7.
At...
July 7, 2008 at 8:46 am
Is this in reporting services? Please post to the appropriate forum. I've moved it there, so post if it needs to be moved back.
If you want to pull data for...
July 7, 2008 at 8:44 am
Viewing 15 posts - 27,931 through 27,945 (of 39,769 total)