an example via xp_cmdshell from an old post;

the obvious problem is the script contains a cleartext password.

if the shared drive was already set up at the operating system level, the...

AndrewSQLDBA (5/14/2013)

---

I have not been able to every find that SSMS will do that. I was hoping that someone had found a way.

I have the SSMS Tools. So how would...

A couple of other ideas ,depending on who it is you want to keep out of the database restore the database with a name noone would connect to.

and another...

S_Kumar_S (5/14/2013)

---

Hi All

I wish to store a word document in SQL Server. I should be able to search on the content. e.g. Select Content from DocTable where content like '%this...

well, the xml you posted is malformed; it is either missing two tags in the middle, or these two tags below need to be removed from the middle:

the...

Sean Lange (5/13/2013)

---

Lowell (5/13/2013)

---

Only because i have a macro that converts pasted text to a CTE; you built a complete sample DDL...

raghusg (5/13/2013)

---

Hi,

We have two different Windows 2008 R2 servers (Server1 and Server2) on the same domain. The questions I have are:

1) Can I have the same...

Only because i have a macro that converts pasted text to a CTE; you built a complete sample DDL for it.

it seems like a basic grouping can get you the data you want;

run this in SSMS, does this give you teh data youa re looking for?

with mySampleData ([Sales Order #],[InvoiceID],[InvoiceDate],...

you need the version with SQL 2012 with Advanced Services or SQL 2012 Express with Tools:

Advanced Services includes the SSMS Express version.

http://msdn.microsoft.com/en-us/evalcenter/hh230763.aspx

http://www.microsoft.com/en-us/sqlserver/editions/2012-editions/express.aspx

since you already installed the Express engine, you could...

Both Have SQL = "Structured Query Language" in their names;

As Far as I know, T-SQL (Transact SQL) is the nickname for Microsoft's version of SQL, as opposed to PL SQL(Oracle's...

That's part of SSIS, so you'd need either SQL Developer, or SQL Standard/Enterprise/Data Center editions. it is not included in the Express editions.

Tim in this case, i'm not sure;

I created a Simple Class library, and this is teh entire code, which compiles correctly in the full version of Visual Studio 2010;

My project...

SpiderDK (5/13/2013)

---

Yes, but this only allows me to group on class / type of statement.

I would like to group simular statements

select * from table1 where id = 1 order by...

also, to create a view on Server 2, FROMserver 1, you need to do one of two things:

either the SQLcmd needs to actually connect to server 2, and not...