opc.three (6/6/2012)

---

Win32_Volume is more appropriate in some server environments. I use Win32_LogicalDisk in this environment as Win32_Volume is not a class on all the servers that I support.

Here is...

I was able to come up with a workaround.

If you delete the log file and revise the script you can attach the database.

I would provide the script but I lost...

I had to restrt SQL Server a 2nd time.

I was stuck at recovery at 0%. It finally moved to 2%.

I had this problem.

I was concerned that if I restarted the SQL Server Service that the Database would perform a recovery.

I checked the error log and I do not see...

Yes Sir.

EXECUTE master.dbo.xp_create_subdir N'E:\Backups\Differential\MyDB'

GO

BACKUP DATABASE [MyDB] TO DISK = N'E:\Backups\Differential\MyDB\MyDB_backup_2013_02_10_205300_1612807.bak' WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N'MyDB_backup_2013_02_10_205300_1202766', SKIP,...

Thanks for responding.

There are no jobs that delete the backups. I installed this server from scratch.

The backup file is not...

The problem was cause by a Local Security Policy.

The fopllowing User Access Control (UAC) Policy setting was the problem:

Only elevate UIAccess applications that are installed in secure locations

The following article...

The following works :

SELECT

CASE WHEN LEFT(Customer.StartDate, 2) = '98' THEN substring(convert(varchar(20),Customer.StartDate), 3, 2)

...

I had to use a CONVERT with the SUBSTRING Function as opposed to the CAST.

This works.

SELECT

CASE WHEN CAST(LEFT(Customer.STARTDATE, 2 AS VARCHAR(2)))

...

Thanks. Not sure why I'm getting an error on the substring function.

Msg 8116, Level 16, State 1, Line 1

Argument data type numeric is invalid for argument 1 of substring function.

Yes, I should have provided the information you requested.

I'm upgrading 22 databases from 2005 to 2008 R2 to another Server this weekend.

I forgot to mention a very important point.

The Date is stored in an AS400 DB2 format.

The 1st character 1 or 0 - Century, where 1 > the year 2000 (21st...

rasika.segan (7/10/2012)

---

There are two things you need to follow:

a. If you using a SQL server destination, switch it to OLEDB destination.

b. Use the Table/View load instead of Fast load.

This would...

If I were to remove my profile then it should clear up the issue with BIDS.

I'm a member of the administrator Group via my membership in the Domain\DBAs Group.

I'm not...

I was able to uninstall and reinstall just the BIDS Component on the Developer PC. However I had to use my Account even thought the Developer was in the Administrators...