Thanks mister magoo! what tool did you use that helps you identify case sensitivity issues like that?

Igor thank you very much for your feedback!

Your feedback was spot on, and the extra pair of eyes helped enormously.

because you gave such detailed feedback, i was easily able to...

i would recommend adding an explicit formatting to the date to guarantee it's converted to YYYY--MM-DD format.

you could potentially be getting dd/mm/yyyy,mm/dd/yyyy or event ""Mar 3 2016" if you don't...

bcp called via xp_cmdshell runs under the context of the service account running SQL, and not as the logged in user who executed it.

the account is probably not a...

There's a nifty builtin function called PARSENAME that splits a string like an Application Versions, IP addresses or Servername.Databasename.SchemaName.TableName into it's parts.

you can use that to isolate the second section...

Sean Lange (3/3/2016)

---

Don't know what you want your trigger to do but be careful. Triggers fire once per operation, not once per row. So you need to create set based...

i did a big Powershell documentation initiative.

this script from awhile ago started it:

Powershell script to script out jobs, databases, users, linked servers, logins, roles, alerts, etc from a list of...

sgrimard (3/3/2016)

---

Good day,

I am wondering what would be the easiest way to recreate an existing database schema (sprocs, tables, constraints, etc..) without the data.

In MSSQL, I know you can use...

as a general rule, if you've deflared @variables, you made a mistake in a trigger, and are limiting yourself to single row data instead if set based.

the issue is your...

kaplan71 (3/3/2016)

---

Hello --

I am running a SQL script that is designed to query the whole log of a particular database. The syntax of the script is the following:

use RayStationMachineDB_472

select *...

EXEC sp_msdependencies @intrans = 1

that will give you all objects in foreign key hierarchy order. it can be painfully slow or never ends if you...

i googled a bit and i saw quite a few blogs and examples on how to do this;

I would recommend starting there:

https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=load+twitter+into+SQL

if it's truly a handful of tables, and the servers can talk to each other, i'd consider using either a MERGE statement or a pair of UPDATE/INSERT;

that assumes that...

I have Redgate SQL Compare, but we do not(unfortunately) use source control for SQL objects.

I have a methodology for this situation that might help, assuming you also have SQL Compare.

In...

you should just pass all the parameters; if one of the columns is a column name, you have to select it from the table;

select dbo.CountOpps(User_ID, @StartDate, @EndDate),*

FROM SOMETABLE