fizzleme (12/23/2016)

---

Just trying to referenced a mapped drive in SQl Agent. The service acct for SQl Agent is a domain acct with local admin rights on the 2008...

Vertigo44 (12/20/2016)

---

We have a few vendors who refuse to push us files. As a result we have a few FTEs that spend a few hours daily and weekly logging into...

Another thing to keep in mind is that some of what you are describing can be totally normal and nothing to worry about. The low PLEs can show when the...

smatu (12/22/2016)

---

I am unable to alter a database table with ddl admin permission. I get the following error:

"You are not logged on as the database owner or system administrator....

DBA.A (12/22/2016)

---

HI team could you please guide

Full ,LOG and diff Backup Maintenance Plan is place in D: drive , now i want to change the place in...

One option is you can do something like this:

INSERT INTO [dbo].[BowtieDMEquipmentLookup] ([EquipmentDescription])

VALUES

('Absorption Column'),

('Accumulator'),

('Adsorption Column'),

('Air Cooler'),

('Air Handling Unit'),

('Air Receiver')

Sue

HappyGeek (12/21/2016)

---

Many thanks for the replies, database owner is sa, there is an entry in event viewer which suggests the login may have changed but not sure how to...

I'm guessing you just left out the AS after the CREATE PROCEDURE.

Just add this to the beginning:

CREATE PROCEDURE GenerateRandomNumbers

AS

then it would have your DECLARE statements and everything...

The requirements for TLS 1.2 (server and client) are listed in this MS article which may help:

https://support.microsoft.com/en-us/kb/3135244

Sue

When you do a reply, look on the left for the IFCode Shortcuts.

When you post SQL statements, click on the one with bracket code=sql

and you paste your SQL...

Try...

fred.schmid (12/20/2016)

---

Yes, I did deploy the new dataset separately. Afterward I deployed the report. That is when I got the error. I have tried removing the dataset...

SQLUSERMAN (12/16/2016)

---

After running my query and checking the Execution Plan in SSMS, I can see that that there is a Clustered Index Scan with a Query Cost of 100%.

I opened...

Senchi (12/15/2016)

---

Sue, I tried your suggestion...

I copied the sp_addlogin

and created a new one.

However, I got the error on :

--execute sp_hexadecimal @passwdbin, @hextext OUT

and

--execute sys.sp_hexadecimal @sid, @hextext OUT

No such stored procedure...

tt-615680 (12/14/2016)

---

The database is in 'Full Recovery' model and there is a regular log backup occurring; which is why I ask the question then reason why the Log wait desc...