Viewing 15 posts - 4,471 through 4,485 (of 7,185 total)
I would recommend that you investigate how much free space you have inside each database before going ahead with this. If your files are full, this isn't going to...
June 1, 2012 at 3:15 am
Lynn Pettis (5/31/2012)
There is no need for the from clause.
Unless, for some bizarre reason, he wants those figures repeated as many times as the function returns rows.
John
May 31, 2012 at 9:45 am
Thanks Lynn. I saw those other threads... just thought I'd try this once. If I don't get the required information, I shan't be asking again.
John
May 31, 2012 at 9:41 am
Please post the whole of your code, including the parts where @temp1 and @ReportData are declared. Please also post the definition of dbo.fRealizedGainLoss and any table definitions and sample...
May 31, 2012 at 9:37 am
You should try to help yourself, and post back if you come across anything you don't understand. I bet that if you typed "How to rename SQL Server" into...
May 31, 2012 at 8:14 am
I've just noticed that you said the server is not in a domain. I think that's your problem - it sounds as if you're trying to run SQL Server...
May 31, 2012 at 7:34 am
Phani
Sure. If you have WinZip or another such utility installed, you can use xp_cmdshell, which you can also use for the COMPRESS command if you have the Windows Resource...
May 31, 2012 at 7:13 am
I've seen that SSPI error occur when a Windows password has recently expired or been changed.
Also, please will you check that the time of your most recent SQLAgent.OUT file coincides...
May 31, 2012 at 7:08 am
craighenderson (5/31/2012)
Can I not just attach the mdf to an instance of SQL Express elsewhere? I'm sure I've done this in the past.
As far as I'm aware, you can,...
May 31, 2012 at 6:14 am
craighenderson (5/31/2012)
I really only want the data from the PC - and to make sure it isnt accessible on the PC anymore
In which case, you will indeed need to detach...
May 31, 2012 at 5:17 am
But then you still have the database online when you restart SQL Server. Wasn't the idea of the exercise to detach it? If you just want a copy...
May 31, 2012 at 5:00 am
Craig
You may need to use the -S parameter in sqlcmd to specify the server, if you use named instances or non-default ports.
John
May 31, 2012 at 4:43 am
Wow! Took a while to get my head round that, but when I did, it made sense. An INSERT statement has to succeed or fail as a whole,...
May 31, 2012 at 4:30 am
The phrase "beer cooler" is anathema to me, since 90% of beers worth drinking here in the UK are served at room temperature (or certainly no colder than cellar temperature)....
May 31, 2012 at 4:13 am
OK, thanks for all the replies. Plenty to think about here.
Hugo Kornelis (5/30/2012)
May 31, 2012 at 2:55 am
Viewing 15 posts - 4,471 through 4,485 (of 7,185 total)