I just wanted to follow up on this just in case anyone was as dumb as me and was using the 2012 version of Profiler to profile a 2014 SQL...

Yes, I'm running Profiler from my desktop but it works fine against servers, i.e. my local installation, to which I have full access. It's only those servers that I...

Of course when the DBA runs it they have higher permission so they don't have the problem.

First, I am not the DBA (unfortunately). Second this is not a production system, it's actually multiple servers in our test environments. I was granted alter trace but...

Jeff Moden (5/2/2014)

---

lsatchell (5/1/2014)

---

This article was the subjectline feature article 2nd May 2014 SQLServerCentral e-mail newsletter.

Come on guys, a circa 2010 solution featuring a VBscript!? Where's the powershell updated...

Any thoughts on using Powershell instead of VB?

Edit:

Apparently DanGuzman and I both had the same thought while not reading the entire thread.

I finally found the problem. Someone in their infinite wisdom decided that every database should have the UDDT in it so they created it in the model database with...

Msg 1781, Level 16, State 1, Line 1

Column already has a DEFAULT bound to...

Sean Lange (3/28/2014)

---

That is the...

Can you elaborate on what the problem is? I assume you must be getting an error message? What version are you running?

What you posted has no primary key and no...

The only difference between the two servers is that my local server is running SQL Developer edition while the Dev server is running Standard Edition.

This is being run in a brand new database on both servers that I'm testing it on.

CREATE TYPE [dbo].[MYGUID] FROM [uniqueidentifier] NOT NULL

CREATE TABLE [dbo].[EmergencyContact](

[EmergencyContactID] [uniqueidentifier] ROWGUIDCOL NOT NULL,

[EmployeeID]...

I just wanted to follow up on this to let people know how this all worked out. What I needed to accomplish was to copy the tables from several...

I know this is an old thread but I recently had to do this and found that the following Powershell commands to be very useful. They only get the...

Sounds appropriate for your environment. I wrote some CLR procs when they first became available but really didn't find a whole lot of use for them. However, I'm...