Have you granted execute permissions to all the procedures to the user or a role he/she is a member of?

You can use a sequence of Execute Package tasks with success connectors. That will make sure you execute the tasks in the sequence you require.

Usually when a developer asks me this question, I find the data in the table in a different database (usually master).

You may want to check other databases.

You could compare to snapshots using SQL Data Compare from Redgate.

You could also do a compare in a query like this:

select * from ShipAddr a

inner join ShipAddrSnapshot b

...

Can you check the services list? If so, you can see of the reporting services is listed.

Also, from SSMS, you could try to connect to reporting services for that...

One way would be something like :

declare @Time int

select @Time = 0630

select

SUBSTRING(CAST(@Time + 10000 AS varchar),2,2) + ':' + SUBSTRING(CAST(@Time + 10000 AS varchar),4,2)

Yea, I noticed that, but I hard-coded the order by thinking he could adapt that if needed. It was the row_number() usage that was key.

Also, I didn't see your...

USE dbTools

GO

CREATE TABLE deed (deed_id INT IDENTITY(1,1), deed_name VARCHAR(25))

GO

INSERT INTO deed (deed_name) VALUES ('Deed F')

INSERT INTO deed (deed_name) VALUES ('Deed C')

INSERT INTO deed (deed_name) VALUES ('Deed I')

INSERT INTO deed (deed_name)...

You could potentially have an issue with identity columns as keys, unless you offset carefully between the two systems. A better solution might be a guid ( NEWID() )...

I think dynamic SQL is your solution here, unless you can set a variable ahead of your query.

I think sometimes we are guilty of over analyzing a problem. Questions such as "How many rows are currently contained in tblUsers?" leads to a judgement that the question...

An email address is a mutable attribute. As such it would make a terrible primary key for a database.

Just because you use a email address to login to Amazon...

Why do you need to delete records?

If you're considering flagging them as deleted, why do you need to delete at all?

In the object explorer, right-click on the database you wish to script. Under Tasks, select Generate Scripts. You can script the tables, views, procedures, UDFs etc. You...

We create identity columns for just about every table. It tends to make things much easier. One such area this makes things easier in is transactional replication.

One area...