Viewing 15 posts - 2,326 through 2,340 (of 2,897 total)
[Col2] [nvarchar](5) NOT NULL CONSTRAINT [DF_TableA_Col1] DEFAULT ('unknown'),
You're trying to insert NULLS into a column that does not allow NULLS
You could add:
WHERE TableB.Col2 is not null
same for Col1 & Col3
October 20, 2007 at 6:24 pm
We give contractors a Windows account, then give them just as much SQL access as they need. If an app needs a SQL login, then we create a specific one...
October 19, 2007 at 11:45 am
We also are pretty happy with Idera's Compliance manager. When I was shopping 6 months ago, I don't think Quest's product had been released yet, so maybe that's why no...
October 19, 2007 at 11:41 am
We recently bought Idera's Compliance Manager. It has lot's of configuration options so you can specify different amounts of detail for different servers & databases. We have some of...
October 19, 2007 at 11:34 am
Is the problem that the resulting database on the laptop is too big, or the amount of space of the database AND the.BAK file ? If it's a transitory...
October 19, 2007 at 11:29 am
"...Am I reading correctly that 2005 cannot be a subsriber to a 2000 publisher?..."
We have a 2005 subscriber to both Snapshot & Transactional subscriptions from a 2000 server .. ...
October 12, 2007 at 2:34 pm
SRB (10/9/2007)
In the properties of the SQL Server Agent, what is the "Alert System" setting for Mail Session. Enable Mail Profile should be checked.
That was it !! ...
October 9, 2007 at 5:42 am
Jo Pattyn (10/6/2007)
TO DISK='\\ServerB\Backup\ServerA\testdb.bak'
*Make sure the executor (sql agent) has enough permissions on the disk
*Try to restore at least one backup. We had issues with windows 2003 without...
October 7, 2007 at 9:46 am
By Best Practices, do you mean make the change with the script, or save the script for historical purposes ?
When I make changes with the GUI, I have set my...
October 4, 2007 at 9:40 am
Or you can do it the easy way with the GUI and get it done in about 4 clicks.
October 4, 2007 at 9:05 am
" ... Members using Internet Explorer will not experience this issue ..."
I'm on IE 6.0.2900.2180
"...If you're inclined, you can switch the angled brackets to & lt ; and & gt...
October 4, 2007 at 7:46 am
I'm in Connecticut, and should have chosen -5, but I had to choose -4 to get the right display.
October 3, 2007 at 1:26 pm
Can't you write your select statement and put that in your filter ? I've done filters so that I only replicate from TableA if I get a good join to...
October 3, 2007 at 12:33 pm
Time Zone error for me too. I had to purposely choose a time zone that's 1 hour earlier than my real time zone in order to get the correct time...
October 3, 2007 at 11:19 am
Viewing 15 posts - 2,326 through 2,340 (of 2,897 total)