Viewing 15 posts - 46 through 60 (of 278 total)
It seems that lately there's another wave of spammers.... the really bad thing is that the links they have in their post leads to highly infected websites. I got my...
May 19, 2010 at 6:54 am
You can create a linked server and then query it into your MS SQL DB. Do a little search on this forum about linking MySQL to MS SQL 😉
May 19, 2010 at 6:39 am
You can actually go with mountpoints and hence not deal with one big drive or drives for the images. Just have different Mountpoints and with those either balance or divide...
May 18, 2010 at 1:45 pm
Your best bet will probably be having just pointers in your database to the actual image location.
Managing Databases with BLOB's and at the rate you state is a nightmare.
Having external...
May 18, 2010 at 10:32 am
Henry Treftz (5/18/2010)
Yes in the best of all possible worlds this would be addressed via the application.I am not looking for suggestions on application development.
In that...
May 18, 2010 at 7:52 am
James Stover (5/13/2010)
May 17, 2010 at 2:13 pm
Henry Treftz (5/17/2010)
It is a currently running query. So what I want to do is basically do send of a raiserror to an existing connection...
...doubt that can...
May 17, 2010 at 1:42 pm
lmu92 (5/17/2010)
Richard M. (5/17/2010)
lmu92 (5/17/2010)
Not sure what you're trying to do but maybe RAISERROR will help (see BOL for details).
... you can't "inject" an error to another SPID....
As...
May 17, 2010 at 1:39 pm
lmu92 (5/17/2010)
Not sure what you're trying to do but maybe RAISERROR will help (see BOL for details).
... you can't "inject" an error to another SPID....
As far as I...
May 17, 2010 at 12:43 pm
In SSMS in the Database where you created the Schema, go to Security-->Schemas
May 17, 2010 at 12:28 pm
Nice one.... also good to use as an interview question 😀
May 14, 2010 at 7:32 am
..... and SQL Express 2008 R2 has now a 10Gb DB limit (same 1Gb memory and 1 processor limit though).
MySQL is a nice alternative. If you really don't...
May 12, 2010 at 7:09 am
Report back: All went well 🙂
For the benefit of other readers:
* Stop the Log Reader Agent and Distribution Agent
* ALTER DATABASE distribution SET OFFLINE
* Move the data and log file...
May 11, 2010 at 9:43 am
OK... Will give it a try and see how it goes. Thanks again.
May 11, 2010 at 9:22 am
Roy,
just to make sure. On the Publisher, I would stop the Log Reader Agent and on the Distributor/Subscriber I would stop the Synchronization ?
After I move...
May 11, 2010 at 9:15 am
Viewing 15 posts - 46 through 60 (of 278 total)