For package execution:

Can you try adding the user to db_dtsadmin ,db_dtsltduser, db_dtsoperator roles in the msdb database in sql server.

Also can you check whether the sql authenticated user has access...

It depends on whats coded in your database scripts, application etc.

If you set it to 90 then it will use features of SQL 2005 and if set to 100...

No. SQL agent restart will in no way effect the SQL Database Engine access.

SQL Agent is used as a job scheduler. so only your jobs will get affected if there...

Sir,

Your date time column is in the middle and not at the end so your query will not work!!!!!!

I would humbly request you to try the query first as I...

Hi David,

You have an incorrect query thats the reason why I asked for sp_help tables.

1. When you do an insert with record_change_date the end then it means the last column...

also Please try executing the query without 'where 1=1' statement

Thanks

Satyen

Hi,

Execute the following on both the tables and paste the output

sp_help 'tableA'

Thanks

Satyen

Hi,

what is your @startdate datatype.

Also can you give an example on what the parameters actual value are and what you want it to look like.

Thanks

Satyen

sorry didnt see the reply.

good work!!!

1. Open SSMS,

2. On Object Explorer, click Connect and database engine.

3. On the connect pane, you can see, server type, servername, authentication...If you go down you can see options...

Please go through the below link

http://www.sql-server-performance.com/2009/identify-missing-indexes-using-sql-server-dmvs/

Check permissions for the service account on the SQL server.

Make it login to a default db

Regards

Satyen

Hi,

It could be corrupted. Try restoring from a full backup.

Regards

Satyen

Hi,

There are two things of settings for default database option.

1. Right click on your login. Check "Default database" on general page.

2. On connect to a new database engine, click on...

Hi,

For known column I use create table and then insert

For creating a table from another table schema I use insert into.

Have used both, but honestly i prefer 'insert into' because...

Hi,

I guess Old Hand suggested the following.

1. create view viewtest as

select [Student Number], IRN, Name, Gender, Address, city, state, zip, phone, birthdate, Grade, Lastname4 + first as 'Homeroom', Teacher...