Are you sure you have both the old and new user on the server? Is it only windows authentication? Do you know the SA account/password? You could also look at...

As with almost everything we do there are multiple ways of doing a task. A method I use to refresh test databases from production is with a Windows Scheduled task...

As Gail mentioned, ask the Business Side to determine what an acceptable level of data loss is to them and the business over all.

Use that to create your disaster...

There are always (usually) multiple ways to do things.

If it were me I would

1. Script out all the Agent Jobs using SSMS.

2. Script out all users (logins and...

Query the Plan Cache using sys.dm_exec_query_stats. There is a column called "last_execution_time".

The code you show looks good.

INSERT INTO table_name

(

ID

, FirstName

, LastName

)

SELECT

ID

, FirstName

, LastName

FROM database.schema.table_name

You could also use the import/export task within SQL Server Management Studio

Funny I just accepted and will be starting a new job in less than two weeks doing that exact thing.

I decided (after discussing with my wife) to take a pay...

The Data center where I work we are actually in the process of assessing different monitoring tools. Management finally realizes we need tools to be able to do our jobs...

Thanks for the question! It helps to reinforce/challenge knowledge. Currently reviewing MCTS 70-432 information so it was a perfect question!

Cheers!

Got it figured out. Just me being stupid. Here is the solution.

SELECT

TFirstName AS FirstName

, LTRIM(SUBSTRING(TFirstName, CHARINDEX(' ', TFirstName) ,2)) AS MiddleName

, CHARINDEX(' ', TFirstName)

, CASE

WHEN CHARINDEX(' ', TFirstName)...

I figured out the issue. I am a DUMBASS!

Looking at the code I displayed. I have a matmsdev database I was working in.

But calling the stored proc in the matms...

Been there done all that and more. That's some of the issue.

Thanks again for the reply(s)

/****** Object: StoredProcedure [matms].[CUSTOMERS_PKG$SAVE] Script Date: 01/27/2010 11:00:53 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[matms].[CUSTOMERS_PKG$SAVE]') AND type in...

I am doing that. I just did not show it in the post. The site id is there. I think it has something to do with the formatting of the...

Wow. Some heated discussion going on here.

I have used "tibbling" before but only because at the time I was a junior DBA/Developer.

I never really got why they would...