Viewing 15 posts - 121 through 135 (of 143 total)
Cough, cough...... :pinch:
Just reread the whole post again. the error is in the create view.
Check constraint for invoice 13453 is in DB 2013, but that's not included in the...
September 28, 2012 at 12:53 am
Oops! :blush:
Thanks Sean!
Haven't used it in many years.
September 27, 2012 at 8:58 am
Maybe an obvious question, but have you tried rebooting node1?
Unfortunately the link doesn't work for me.
Goodluck.
September 27, 2012 at 8:52 am
Hi,
This code helps me keep track of what's being backed up, and more importantly, what is not.
You'll need a DB and table to store the data in.
ALTER PROCEDURE [dbo].[usp_GetSvrDBBackups]
September 27, 2012 at 8:47 am
I have been trying to recreate this, thinking it was a bug. Looks like it isn't.
This test DOES work.
-- Create test tables
CREATE TABLE Invoicing_2004..T1 (Val Int PRIMARY KEY)
CREATE TABLE...
September 27, 2012 at 8:27 am
Hi,
Thanks for responding.
The code is preety straight forward.
CREATE VIEW InvoiceData
AS
SELECT *
FROM Invoicing_IVS..InvoiceData_Actual
UNION ALL
SELECT *
FROM...
September 27, 2012 at 8:23 am
Hi,
Sorry don't know too much about this yet. But here are a couple of links i'm reading at the moment about this....
http://msdn.microsoft.com/en-us/library/bb934049%28v=sql.105%29.aspx
http://msdn.microsoft.com/en-us/library/bb895327%28v=sql.105%29.aspx
Hope this helps.
Goodluck.
September 27, 2012 at 7:37 am
Hi,
Before inserting the data, find out what the MAX(LEN(Col)) is for each column. Compare the results to your variable declarations and destination table design.
Btw, varchar(max) isn't recognized in SQL...
September 27, 2012 at 7:30 am
Hi,
Maybe it's an idea to find out WHO are creating all these objects and why. Could be that they need their own test environment. Even if you find a...
September 27, 2012 at 7:22 am
Hi,
Try checking all logins you are using throughout the whole process, including all services accounts.
In the jobs list, take a look at the history. Maybe that will give more idea...
September 27, 2012 at 7:07 am
Hi,
It's not clear what your issues is.
If your cluster isn't allocating resources correctly then I don't think you are posting in the right place.
Make sure your cluster is working properly....
September 27, 2012 at 7:05 am
If you have access to SSMS 2008 you can right click on the instance name and select Activity Monitor.
This will give you a good place to start troubleshooting.
September 27, 2012 at 6:57 am
Make sure no other instances of SSMS are open.
If you have multiple tabs open, make sure they are not pointing to the DB in question.
You could also try restarting the...
September 27, 2012 at 4:48 am
Hi,
Just was reading about this. I think you should take a look at these posts for a more in depth explanation and comparison.
http://archive09.linux.com/feature/142658
http://www.novicksoftware.com/Articles/sql-server-ssd-solid-state-disk.htm
Looks like...
July 4, 2012 at 5:38 am
Viewing 15 posts - 121 through 135 (of 143 total)