Viewing 15 posts - 46 through 60 (of 275 total)
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
Roy,
thanks for your answer.
I already tried that. Trying to set the distribution database offline will hang forever, because it is being blocked by some of...
May 11, 2010 at 8:52 am
"around 11 gb of data on their personilized desktops." on a production SQL Server??? I didn't even mention to look into this because i assumed that there *should* be no...
April 28, 2010 at 9:45 am
Viewing 15 posts - 46 through 60 (of 275 total)