Viewing 15 posts - 1,276 through 1,290 (of 7,168 total)
What is the proc doing? Can you post the code?
April 12, 2013 at 8:24 am
erikd (4/11/2013)
The other fields it's occurring in are first name, last name, and company name. Crud.
It should be a quick fix to the cursor declaration I showed above so those...
April 12, 2013 at 8:23 am
As suspected
[Prefix] [varchar](64) NULL,
in the "load" table is the best candidate for causing the issue. Should be NVARCHAR.
April 11, 2013 at 10:06 pm
Where I have your workflow:
1. dbo.LoadPreLoadFromExcel brings the contents of the Excel into a new "load" table
2. dbo.CreateTargetTable creates a new "target" table with typed columns from data in sample_fields...
April 11, 2013 at 9:32 pm
You cannot rely on sys.server_principals to resolve the names of job owners that are entering the instance via a Windows Group. Use SUSER_SNAME() instead:
SELECT sj.name AS 'job',
...
April 11, 2013 at 8:45 pm
Jeff Moden (4/11/2013)
opc.three (4/8/2013)
If nuclear blasts were the only reason to leave xp_cmdshell disabled then you would have a great point. Unfortunately, that is simply too narrow a view.
The circle...
April 11, 2013 at 8:41 pm
I need the contents of Sample.dbo.sample_fields in order to know the second table definition. Can you simply script out the resulting table definitions for the project_id in question?
This query in...
April 11, 2013 at 8:16 pm
Cool. I can't get to dropbox from here but I'll have a look when I am home.
April 11, 2013 at 1:36 pm
If you do not need unbroken sequence don't reinvent the wheel, use an IDENTITY column. It hamdles concurrency for you and when relying on auto-generation will guarantee uniqueness.
April 11, 2013 at 9:37 am
Sure. Post it. If you want to attach some sample UPDATE statements and the table defs too as a text file so the browser doesn't get in the way that...
April 11, 2013 at 9:34 am
Steve Jones - SSC Editor (4/10/2013)
In 2008, you should have queueing. DB MAil uses Service Broker under the covers, so I wouldn't worry about that.
+1 Database Mail in 2005+ uses...
April 11, 2013 at 9:05 am
You are sure nothing else changed with the service account? Check the SQL Server error log for messages about the SPN being registered where it wasn't before the change, or...
April 11, 2013 at 9:01 am
For terminology's sake so we're speaking the same language:
ANSI = VARCHAR/CHAR
Unicode = NVARCHAR/NCHAR
In SQL Server, Unicode = UCS-2
Still not clear if all your columns are Unicode or whether you have...
April 11, 2013 at 8:53 am
What happens if after you get the next number from [dbo].[GetNextRowId] you try to do the insert into the base table and it fails? That's the same problem an IDENTITY...
April 11, 2013 at 8:47 am
April 11, 2013 at 8:02 am
Viewing 15 posts - 1,276 through 1,290 (of 7,168 total)