rajemessage 14195 (11/17/2016)

---

hi,

1) select * from abc where abcid =(select top 1 abcid from xyz where xyzid =@xyz)

2) Select * from df where dfid in (select...

Because it happens only occasionally: could it be an existing file must be overwritten, which is already (or still) locked by another process?

Something like a backup that is created to...

Harshana-455711 (11/15/2016)

---

Hi

We have SQL Server 2012 Standard Edition without any service pack so we need to upgrade to SP3. can we do the in-house upgrade ?. Appreciate your feedback on...

Glad I could help, and thank you for reporting back. This can help others who stumble upon this thread.

The SID on a SQL login can be specified but the SID of a Windows account is defined on Windows level (like in Active Directory). If you want the SID...

I'm not familiar wirth C#, but shouldn't you pass a value for the ID parameter (see bold part below)?

<snip>

...

wikus (11/14/2016)

---

CREATE TABLE [dbo].[Table_1](

[Col1] [nchar](10) NULL,

[Col2] [nchar](10) NULL,

[Col3] [nchar](10) NULL,

[Col4] [nchar](10) NULL,

[Col5] [nchar](10) NULL

) ON [PRIMARY]

INSERT INTO Table_1

VALUES (1,'AAA','xyq',345,'eyrt'),(2,'CCC','frt',456,'kjhg'),(3,'AAA','kkj',367,'uytr'),(4,'DDD','hhh',543,'fdds'),(5,'CCC','xyt',457,'ewqq'),(6,'AAA','iuy',872,'lkji')

The reult should be:

Col1Col2Col3Col4Col5

1 ...

lmarkum (11/11/2016)

---

This is a data warehouse SQL Server instance and there is a nightly job that runs at 9 pm. Part of what it does is restore several databases, one...

Welsh Corgi (11/11/2016)

---

I need to Log on to SQL Server as a different Windows Account.

I tried the following but it did not work.

“Right Click” with Shift key pressed and then...

Rob-350472 (11/9/2016)

---

I've just seen that but it doesn't actually seem to be an option in 2014... not sure if it's only in 2012 or 2016 :/

This suggests it's in...

I don't have SQL2014 but perhaps take a look at the settings in SSMS:

> Tools - options - Query results - SQL Server - Results to Grid - "Retain CR/LF...

sqlfriends (11/8/2016)

---

I would transfer jobs from one server to another server.

I can script out using SSMS for all the jobs using object detail view.

But I found there are no schedules...

Try to connect using the DAC (Dedicated Admin Connection). If that is also not possible, you'll need to stop the SQL Server service and start it from the command prompt...

You should start with a procedure to create the default tekst of the mail and insert the customer name dynamically. Basically the query will look like:

SELECT 'Dear '+name+', {add you...

Is the backup location set in the Instance properties (section: Database Settings)