Hello,

I assume you have a very good reason for wanting to learn the 2000 version of SQL Server, as I guess you are aware that there are free versions of...

Hello,

Is this issue on a Production or Test/Dev DB?

If it is Production then I assume you are regularly backing up the Transaction Log. This is what allows “old” Transactions to...

Hello again,

Does this link help:

http://www.sqlteam.com/article/debugging-stored-procedures-in-visual-studio-2005

Regards,

John Marsh

Hello,

If you have Visual Studio there is a Debugger included that you can use with SPs. There isn’t one in SSMS 2005.

Regards,

John Marsh

Hello,

Is this issue possibly related to permissions of the Account under which the SQL Server Agent Service runs?

One way to test this theory out is to temporarily change the SQL...

Hello,

We use RedGate’s Data Compare to refresh data in tables e.g. from UAT to Dev.

If you don’t have Data Compare or the budget to buy it, then there other similar...

Hello,

To get the full definition for multiple SPs you could use the sys.sql_modules view.

So something like:-

SELECT sm.object_id, OBJECT_NAME(sm.object_id) AS object_name, o.type, o.type_desc, sm.definition

FROM sys.sql_modules AS sm

JOIN sys.objects AS o ON...

Hello,

The statement “Insert into BrandsMachine(MachineID)” will fail because a column that participates in the PRIMARY KEY constraint cannot accept null values and you are not supplying a value for BrandID.

You...

Hello,

If you subtracted the result of DatePart(wk) for the first day of the Month , from the DatePart(wk) for the Date you are calculating, and then add one, would that...

Hello,

May be take a look at this article:-

http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1172656,00.html

Regards,

John Marsh

Hello,

You can use the SQL Server Import Wizard and select the Flat File as the Source.

The Wizard allows you to store the settings that you select as an SSIS Package...

Hello Steve,

As it is an intermittent problem, I would think it is as the message suggests a Network issue.

When you get the connection failure message in SQL can you...

Hello,

I am just trying to understand your issue properly. Do you want the user to be able to select from a list of Servers and then the report will only...

Hello again,

When you say a “pop up window” does that mean you get this error when you call it from an application? (.Net?) If you execute the SP from an...

Hello,

Does the available Log Space increase when you do a Log backup?

You could increase the size of the Log file, but that would just buy some time to investigate the...