What we do, that account has very limited permissions on the...

What are you doing to get the above pictures. It doesn't look like you have any ordering applied (considering your number go ...336, 337, 338, 1, 2... in your image).

I...

If you're going to way,...

Maybe?

EXEC sp_readerrorlog 0, 1, 'Tempdb'

You'll need to change the value of the first parameter to go back through your archive files.

Adi Cohn-120898 (12/6/2016)

---

Thom A (12/6/2016)

---

Further Question, why ARE they a member of the db_datareader and db_datawriter roles when they are a member of db_owner role? These roles serve no purpose,...

Further Question, why ARE they a member of the db_datareader and db_datawriter roles when they are a member of db_owner role? These roles serve no purpose, as db_owner grants all...

There's your problem.

db_owner's can do what every they want, whenever they want, in that database.

Personally I use the same logic in SSRS that I use in SQL, which is:

DateFrom

=DATEADD("M", DATEDIFF("M", "01/01/2000", DATEADD("d", -1,TODAY())), "01/01/2000")

DateTo

=DATEADD("d", -1,TODAY())

Today, that would return 01-Dec-2016 and 04-Dec-2016 respectively. Running on...

RonMexico (12/5/2016)

---

Sue - I must not be setting it up correctly when trying to follow your advice. What permissions do I grant at the database level that won't apply...

Thats not what I was saying, you need to escape the special charaters:

exec xp_cmdshell 'dtexec.exe /F "D:\DBUpdates\Mypackage.dtsx" /SET "\package.Variables[User::JobLoginPassword].Value";"8\:\;xLuZc"'

Field type text is deprecated, I would definitely use VARCHAR or NVARCHAR. ntext, text, and image (Transact-SQL)

Are you going to be comparing any other fields as well? As you're on...

The escape character for SSIS Expressions is a backslash (\). So, a variable of value; abc"123; would be: ="abc\"123\;".

Using your example:

USE DevTestDB;

GO

CREATE TABLE #Emp (ID INT IDENTITY(1,1),

TNum VARCHAR(12),

...

As Steve said, we don't have a lot to work with here.

The field your testing is clearly a INTEGER, so I'm wondering why you're wrapping it with single quotations....

vkundar (12/2/2016)

---

I need a code which will check the AAG name and its role , if it is primary then all the jobs status will enabled else disabled. We have...