Viewing 15 posts - 1 through 15 (of 85 total)
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...
June 11, 2015 at 6:46 am
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...
April 28, 2015 at 7:03 am
Of course when the DBA runs it they have higher permission so they don't have the problem.
April 26, 2015 at 1:21 pm
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...
April 24, 2015 at 9:33 pm
Jeff Moden (5/2/2014)
lsatchell (5/1/2014)
Come on guys, a circa 2010 solution featuring a VBscript!? Where's the powershell updated...
May 2, 2014 at 9:16 am
Any thoughts on using Powershell instead of VB?
Edit:
Apparently DanGuzman and I both had the same thought while not reading the entire thread.
May 2, 2014 at 7:51 am
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...
April 1, 2014 at 10:12 am
How do you know it fails? You must be getting an error message to know it fails?
Msg 1781, Level 16, State 1, Line 1
Column already has a DEFAULT bound to...
March 28, 2014 at 11:00 am
Sean Lange (3/28/2014)
buddy__a (3/28/2014)
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.
That is the...
March 28, 2014 at 10:57 am
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...
March 28, 2014 at 10:55 am
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.
March 28, 2014 at 10:48 am
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]...
March 28, 2014 at 10:25 am
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...
March 21, 2014 at 9:28 am
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...
March 18, 2014 at 3:14 pm
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...
November 19, 2013 at 3:14 pm
Viewing 15 posts - 1 through 15 (of 85 total)