The .. means use the table that the user has access to owned by anyone which is implied.  Generally means dbo owner though in some shops it means owned by...

I generally use BACKUP LOG dbnamehere WITH NO_LOG.

If you want to get rid of the LOG file i.e. DELETE it....

BACKUP your DATABASE.  DETACH it.  Go to the directory where the...

Ben,

I would research the possibility of using an INTEGER field instead of CHAR(8).  This way you could do simple math instead of

DATEADD(DAY, 90, NewspaperDate) == NewspaperDate + 90

I...

In this limited scope I have FINALLY found a VALID use for CROSS JOIN

USE pubs

SELECT SUM(A1.RecCnt + A2.RecCnt)

  FROM (SELECT COUNT(*) RecCnt FROM dbo.authors) A1

    CROSS JOIN (SELECT COUNT(*) RecCnt...

I don't think you can without dropping and re-creating the table.  You can add the column to the end and then via EM move it or just create it in...

hmmm.

Have you checked both servers and made sure that MS DTC is running??  I would check the linked server and make sure that RPC and (I forget the other) are checked...

Unfortunately, depending on the TYPE of the linked table will depend on this answer...

If the linked table is SQL then YES, IF Excel, Access, Text file, etc... then no.  This...

CHARINDEX or PATINDEX (reference in BOL) will perform what you are looking for 🙂

Are your DB's set to auto-close?  It could be too that just the volume of DBs is causing this.  Sounds like a good time to get coffee (or tea) .

Right-click on the server and click properties.  If you see the last 2 sets are like CS_AS or CS_AI then your server is CaSe SenSitive.  Only way of getting around...

How bout something like

DECLARE @Days INTEGER

DECLARE @Year CHAR(4)

SET     @Days = 61

SET     @Year = (SELECT CAST(DATEPART(YEAR, GETDATE()) AS CHAR(4)))

SELECT DATEADD(DAY, @Days, '01/01/' + @Year)

messages have been posted against the same subject/message:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=129575

When EM freezes and/or the intranet application try and have one of the network/system engineers look at the server CPU's, memory and bandwidth usage.  It may not be "freezing" but...

Personally I prefer SP's and VIEWS to access data.  I prefer the 1st option because IF you remove all permissions to the tables and provide EXEC to sp's then you...

For this application dont set @Return as an OUTPUT variable.

Try adding ISNULL(@SQL, '') <> '' to your BEGIN as well.

What you told the app with the OUTPUT was that it was...