Viewing 15 posts - 6,466 through 6,480 (of 18,926 total)
Move to sql 2008 ent or sql 2008 R2 standard.
You will have access to data and backup compressions which in theory could cut that time by a factor of 2...
May 4, 2011 at 7:21 am
Expect to be minimal.
Install a trial version and test the migration process. Unless you are using depreciated function you should be fine.
That's where upgrade advisor is your...
May 4, 2011 at 7:02 am
Andy Warren (5/4/2011)
May 4, 2011 at 7:00 am
Can't do it. You must either restore and delete the excedent. Backup, ship to QA and restore.
Red-Gate has a tool that reads to bak file and "hosts" it...
May 4, 2011 at 6:59 am
GilaMonster (4/30/2011)
Please note: 6 year old thread.
I wonder why it bothers you that people "activate" old threads?
May 4, 2011 at 6:53 am
I have a similar issue here (SQL 2005, standard SP3 32 bit on windows 2003).
Next time it happens open up task manager. Add the columns (view menu) so that...
May 4, 2011 at 6:47 am
I don't see why not. I have 2008 run on 2005.
As long as SSRS can connect to the db and read the data it should be able to report...
May 4, 2011 at 6:30 am
Another usefull-ish refference for you
May 4, 2011 at 6:28 am
Not 100% sure this applies to you but comming from Paul Randal, I'd listen!
May 4, 2011 at 6:28 am
deba_20032004 (5/3/2011)
I want to know if a user login in a application the username or login name can be displayed in sql profiler as system login in sql server...
May 4, 2011 at 6:24 am
Ronald H (5/4/2011)
May 4, 2011 at 6:16 am
SQLRNNR (5/3/2011)
Ninja's_RGR'us (5/3/2011)
SQLRNNR (5/3/2011)
Ninja's_RGR'us (5/3/2011)
GilaMonster (5/3/2011)
I've seen someone cause 4 hours additional downtime...
May 4, 2011 at 6:02 am
Syed Jahanzaib Bin hassan (5/4/2011)
http://msdn.microsoft.com/en-us/library/ms179296.aspxhttp://msdn.microsoft.com/en-us/library/ms175976.aspx
http://sqlblog.com/blogs/eric_johnson/archive/2010/10/12/tsql-try-catch.aspx
Nice links, can you help me spot the paragraph that talks about debugging a proc that compiles, catches the error but repeats it in those links?...
May 4, 2011 at 5:51 am
pss.srinivasan (5/4/2011)
HiFirst fetch the record the use continue.
like below.
begin catch
if error_number() = 2725 begin
Fetch the Record
continue
end
end catch
We can't help you pinpoint the problem without seeing exactly what code you...
May 4, 2011 at 5:48 am
mark hutchinson (5/4/2011)
SQLkiwiIs there a reason you didn't use the Split() method for C# strings?
http://msdn.microsoft.com/en-us/library/ms228388(v=vs.80).aspx
:w00t: > love this question.
can't wait to hear the answer !
May 4, 2011 at 5:47 am
Viewing 15 posts - 6,466 through 6,480 (of 18,926 total)