Hi Max,

How is your connection defined? SQL authentication or Intergrated authentication?

How do you test it? On the same server or from a laptop for example? Sinc eyou mentioned a domain...

sp_columns shows the length of the column in the database. The error message propbably indicates that the length 3 is in the data flow column in the package. have you...

Anyone tried to create a trigger on a system table?

Could we do Instead of (or other type of) trigger on [msdb].[dbo].[backupmediafamily] ? The backup location is inserted there into...

Well, if you are not up to chocolate cake and you are paid to prevent problems:

- send me the name of the company where they do that

- set up an...

Andrew,

SQL Server 2000 does have server traces. "Catch them all..." with setting a trace on Backup Database statement - text data like 'Backup Database". Then charge a chocolate cake per...

Just curious what SQL Server version you are using?

2008 and 2012 have Policy Management under Management. I am sure you can find something there to limit Backup statement in stored...

Hi,

We had a similar experience with one of the CRMs. We has slow long distance performance. The reason was that this application is server-performance centric - instead of issuing a...

Hi,

yes, you can run SSRS on Standard edition.

Please review comparing features by edition

http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).aspx/css

Features Supported by the Editions of SQL Server 2008 R2

and scroll down to the Reporting section....

Thank you for sharing with us. Could be a bug or something but nice to know we have the explanation

Do you see the table in SSMS? I you do, what happens when you right-click it and select "top 1000 rows"

send us the one line result for this table for this:

select * from sysabjects

Could be also a permission issue but for what? If select would be denied to you for...

Well, even a senior DBA has to add [schema name]

I just reproduced your issue.

When I ran on one of my databases

select top 1 * from [my database].[my table]

I...

Hi Webrunner,

I like your joke about SQL Server Query in a bar.

As you say you have 20 to 30 users and probably guessing no more than 5 people will run...

Please check who is the object / schema owner. maybe it is not you.

don't we use the syntax [database name].[schema name].[object name]

Check the security, what rights do you...

Ah, Ah - sorry was very busy but now read your description. Looks like your file has been created on UNIX or LINUX.

In Windows the row terminator in CR...