Ed Wagner (11/21/2016)

---

Jeff Moden (11/21/2016)

---

I have to do some more research on it but it may be time for me to get ready to retire.

[font="Arial Black"]Microsoft Replaces Command Prompt with...

zoggling (11/21/2016)

---

Will an index not just potentially slow things down further?

Can you see any way in which this trigger can be improved? This seems to be our sole (and frequent)...

Here is the forum etiquette link: http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

Notice how striking a resemblance your test data bears to that shown in the 'The Wrong Way to Post Data' section.

If you want a...

Nagaram (11/21/2016)

---

Hello Experts,

When I SSIS package from SQL Server Agent, getting error as below

"Description: Integration Services evaluation period has expired. End Error Error: 2016-11-21 16:00:00.96...

You've been here long enough to know what is required: sample DDL, INSERT statements containing sample data and desired results based on your sample data, please.

Super_Grover (11/20/2016)

---

Hi, sorry in advance for the n00b questions, but I'm very new to SSIS.

Here's the story: for my work I need to transfer around 200 tables over VPN to...

You may need an additional index or two to help speed up those queries.

I'd consider adding one on the Records table (OtherId, RecordId, ACTIVE).

Did you add variable 'User::ValidationErrorMessage' to the list of ReadWrite variables in the Script Task's properties?

homebrew01 (11/18/2016)

---

For testing, should I be able to do an "In-Place" upgrade from SQL 2005 to 2016 ?? Or is that too big a jump ?

This is only for...

caspersql (11/18/2016)

---

Thanks for the reply Thom. How do you think people generally work with these servers then? If they can't connect through SSMS due to not having the...

planetmatt (11/18/2016)

---

Phil Parkin (11/18/2016)

---

I suspect that the ? is not a ? in the data ... it's some other non-printable character.

This code snippet shows that ?+ is no problem:

IF OBJECT_ID('tempdb..#test',...

I suspect that the ? is not a ? in the data ... it's some other non-printable character.

This code snippet shows that ?+ is no problem:

IF OBJECT_ID('tempdb..#test', 'U') IS NOT...

--Edit: removed silly question

planetmatt (11/18/2016)

---

I have a simple package that takes data from a SPROC and puts it in a .CSV file.

Until today, it ran without issue.

The error it's now throwing is

"The data...

tocy1980 (11/18/2016)

---

I have tried this:

and it doesn't work.

Get this error: he multi-part identifier "Linked Servers.DATA STORE LINKED.'ET NEW$'.Parts Used" could not...