I recommend you to visit the Red Gate website for support, and their forum is great at answering questions

http://www.red-gate.com/MessageBoard/viewforum.php?f=81&sid=3ce1593f0857f1f155d85e78bac7db82

http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Compare&c=knowledgebase\SQL_Compare\KB200712000206.htm

I believe to integrate SQL Compare with Version Control software, you may...

Didn't read in detail

but for a SSRS report, if you try to use a field NOT inside its group

you can only use AGGREGATE functions or FIRST/LAST etc...

so you could have...

I would think it's doable, never done it

At times I create Alias in SQL Server Configuration Manager under the SQL Native Client Configuration

e.g. I can call it "Jerry" pointing to...

I have just changed 2 NAMED instances (on 2 servers in Active-Active cluster) via SQL Server Configuration Manager

No issues after restart successfully

e.g. "SQL Server 2005 Network Configuration"

Protocols for SERVER1, TCP/IP

Protocols...

jeffrey yao (11/18/2008)

---

Good article to read, and I'd especially echo this:

"The scary part about being a new DBA is that you don't know the extent of what you don't know".

In...

SSC has an article recently covering the Default Trace

http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

I don't have a code handy for SQL 2000

but this one works in 2005 & 2008

--Author: Saleem Hakani (Microsoft Corporation)

--Email: Saleem@sqlcommunity.com

--Website: http://www.sqlcommunity.com

--Date: June 3rd 2008

--Purpose: Provide SQL Server Agent related...

I suppose it can work both ways

Personally I think Facebook profile is riskier than Google'ing and find one's posts in a SQL forum (which is related to one's job)

I have...

Not sure what the article is (no link)

but to get a source code of a stored proce (system or user)

sp_helptext sp_who2

Unless it's encrypted, it should give you the source code

If you ran that BACKUP command manually, does it still give you the error?

Maybe someone cleaned out some space?

And make sure it is writing to the correct location (namely, F...

above poster is right

Does the new box freeze without SQL Server installed or running?

My bet is hardware too, but that's what every DBA likes to say 🙂

bang725 (11/17/2008)

---

use the below script

_________________________________________________

Dim fso,fol,fx

set fso = CreateObject("Scripting.FileSystemObject")

Set fol = fso.GetFolder("F:\BACKUPS\")

For each fx in fol.Files

if datediff("d",fx.DateLastModified,now()) > 7 and right (fx.path,4) =".bak" then

fso.DeleteFile fx.Path

End if

next

set fso=nothing

____________________________________________________

goto- job - newstep...

Consider it just came out RTM in Aug 2008, SP1 may be a while

You should see SQL 2005 SP3 released before 2008 SP1 (SP3 is released as CTP/Beta already)

You can use both (Windows or SQL)

Are you asking for the SSRS service account

or the report execution at run time?

Either way, you can use either