Selecting all records from large tables didn't work for me in past as well when I opened tables using right click. So the top query is just simple check to...

Hi,

Can you select from this table from Query Analyzer or SQl Server management Studio using this query?

select top 100 * from tbl_merchandising_profiles_merlive

Try to recreate index with option IGNORE_DUP_KEY = ON (CREATE INDEX ... WITH DROP_EXISTING = ON, IGNORE_DUP_KEY = ON )

Hi,

In SQL Management Studio right click database-> tasks->Generate scripts. Select "Stored procedures" as Object Types and don't forget to script objects permissions under Script Options.

Hi, you can start with this query and then add sys.dm_exec_query_stats:

select s.session_id,s.login_time, s.login_name, s.program_name, r.sql_handle,

( SELECT TOP 1...

You can setup alert similar to the one you have:

- change alert Type to "SQL Server performance condition alert"

- select Object "SQLServer:Databases"

- select Counter "Log File(s) Size (KB)"

- specify database...

Check database Autoshrink option. Is it on?

I would use backup and restore instead of attach DB. This works 100%.

You can use SQL query: "select name from sysobjects where xtype='U' and name like 'App%' " as your first step in DTS package, pass table names to the variable and...

Does your SQL Server service account has "Lock pages in memory" rights on the server? We had similar issue until we gave these rights to the service account. Local Administrator...

Hi,

You can try SQLCMD utility:

- create xml.sql file

:XML ON

select top 10 * from Address for xml auto

- start cmd.exe, run this command:

sqlcmd -S SQL2008 -E -d TestDB -i C:\xml.sql...

Hi,

Here is how I tested it:

1) logged in as sysadmin to SQL Server and created test user "user1", added user1 to the "SQLAgentUserRole","SQLAgentReaderRole" in msdb database

2) created test job with...

Great question! I missed rollback and got it wrong.

Hi,

Have you read this article? http://www.sql-server-performance.com/articles/dba/sql_server_job_proxy_account_p1.aspx

I think it explains perfectly how to run jobs as different login.

So, what are you trying to achieve? To change the job owner or execute the job as specific user?

Did the job run on schedule or you executed it manually?