Hi

To find out which object is referenced by any other use:

SELECT OBJECT_NAME(referencing_id) referencing,

OBJECT_NAME(referenced_id) referenced,

*

...

Hi

What do your start/end parameter depend on? If they are relative to to the current date you can calculate them first and then call the procedure.

Greets

Flo

Hi

We have also some servers with SSE 2000 and SSE 2005 instances on same server. Since now we had no problems with this.

Greets

Flo

Hi

If you are using SQL Server 2005 or later you should have for the CREATE SYNONYM clause. Snippet from BOL:

EXEC sp_addlinkedserver Server_Remote;

GO

USE tempdb;

GO

CREATE SYNONYM MyEmployee FOR Server_Remote.AdventureWorks.HumanResources.Employee;

GO

Greets

Flo

There seems to be a problem with the forum...

Please use following link for replies: http://www.sqlservercentral.com/Forums/Topic683335-338-1.aspx

Hi

This works:

SELECT *

FROM OPENQUERY(LinkedServerName, 'EXECUTE RemoteDatabase.dbo.usp_test')

Greets

Flo

Hi

This works:

SELECT *

FROM OPENQUERY(LinkedServerName, 'EXECUTE RemoteDatabase.dbo.usp_test')

Greets

Flo

Hi

This works:

SELECT *

FROM OPENQUERY(LinkedServerName, 'EXECUTE RemoteDatabase.dbo.usp_test')

Greets

Flo

The data of your teacher already contain a specific person_id so you cannot use an IDENTITY column.

* First you have to insert the person with chief_id = NULL (the president)

*...

Your personal table does not contain an entry with person_id "1".

Greets

Flo

Hi

The script cannot work. First you drop the PERSONAL table (if not only part of this sample).

If the DROP was just for the example ensure that your foreign keys point...

Hi

The permissions are not needed for the INFORMATION_SCHEMA.COLUMNS but for the objects.

You have to GRANT the "VIEW DEFINITION" privilege for the tables to show the defaults for. (I hope this...

H Ganesh

This depends on definition of this view. Use this on master (maybe works also on other database) to see the view creation statement:

DECLARE @v-2 nvarchar(max)

SELECT @v-2 = definition from...

andrewd.smith (3/24/2009)

---

You should use a Tally (or Numbers) table for this. There are several articles about Tally tables on this site. You can join to your table to a...

Hi

You can use a recursive CTE with a counter like this:

DECLARE @t TABLE (id INT, product VARCHAR(100), qty INT)

INSERT INTO @t

SELECT...