Viewing 15 posts - 8,491 through 8,505 (of 9,725 total)
Your biggest worry will be when two people try to change the same record & same field to two different things.
Say I have an auto insurance policy set as...
February 13, 2009 at 8:07 am
Glad I could help.
Let us know if you have any more questions after you're through gathering. @=)
February 13, 2009 at 7:45 am
Just because the server name is correct in the C# code, doesn't mean it's correct in the T-SQL Code. That's why you were asked to check it.
As far as everything...
February 13, 2009 at 7:44 am
Chandu,
Ditto on the password comment of the previous poster. As far as adding a user to the server via VB, all you have to do is use VB to run...
February 13, 2009 at 7:32 am
In addition to the above, you'll want to check the Activity Monitor in the GUI as well as employ Profiler to see if there is a specific process or query...
February 13, 2009 at 7:26 am
Nikhil (2/13/2009)
When i execute following statement through query analyser it works fine.
its gives out put for all databases. but when i run this through Excel sheet
from Data>>New database query
it...
February 13, 2009 at 7:23 am
Ah. Third party vendors. HappyHappyJoyJoy. @=)
I'd get mailtrust.com involved in this. It could be a domain trust issue or an error on their side or a firewall issue.
Also, check with...
February 13, 2009 at 7:19 am
I've heard those too. I certainly will. @=)
Hmm. I also need to write another article for the site. I wonder what I shall compose...
February 13, 2009 at 7:17 am
I don't like your setup. Mirror the transaction files, by all means, but I don't see a reason to stripe them across multiple disks. That seems like a waste of...
February 13, 2009 at 7:15 am
Ditto to the last post. Don't kill a rollback unless you have extenuating circumstances and don't care about possible data / log file corruption. By extenuating circumstances, I'm talking about...
February 13, 2009 at 7:09 am
It does affect read performance pretty heavily. As Gail said, test this first before pushing it into Production. And when you do, put as full a load on your test...
February 13, 2009 at 7:06 am
A couple of questions:
1) Are you absolutely SURE that the mail server you're trying to use supports SMTP mail and isn't just an exchange server?
2) Are you using the actual...
February 13, 2009 at 7:05 am
Check out this topic in BOL:
database mirroring [SQL Server]
It should give you all the details.
But don't enable it just to get rid of the message. That's bad practice. Only enable...
February 13, 2009 at 7:01 am
I don't remember what they are off the top of my head, but there are specific things you need to do before you can run DTS packages from SQL 2k5....
February 13, 2009 at 6:59 am
When running the query, there are other things you can do too.
1) Use Profiler on the destination server to see if anything's actually making it to the server
2) Use sp_who2...
February 13, 2009 at 6:55 am
Viewing 15 posts - 8,491 through 8,505 (of 9,725 total)