It would be prudent to spend some time and forecast future growth, account for partitions, file groups, etc. The idea is to make the data file(s) large enough up front...

You could also use an SSIS script task -

Option Strict Off

Imports System

Imports System.Data

Imports System.Math

Imports System.IO

Imports Microsoft.SqlServer.Dts.Runtime

Public Class ScriptMain

Public Sub Main()

...

I've used this method since 2K. Updated recently to use database mail and format a nice HTML table 🙂 Just need to change the parameters for sp_send_dbmail.

I sometimes have problems...

Here's Microsoft's take -

http://msdn2.microsoft.com/en-us/subscriptions/aa948867.aspx

I suppose it depends on the type of subscription, i.e. volume license vs. retail. I've never had problems using MSDN versions of SQL 2005 Standard/Enterprise under...

Have you checked to make sure the file itself isn't marked read-only?

SQL Server 2005 supports 70, 80 and 90 compatibility modes. Please note that when you attach an 80 database from SQL 2000 to SQL 2005 it upgrades the system tables,...

Build 09.00.3215 (cumulative update) is the most recent. For a list of builds that were released after SP2 was released (this page is maintained regularly)

http://support.microsoft.com/kb/937137

USE [master]

GO

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'DefaultData', REG_SZ, N'D:\MSSQL.1\MSSQL\DATA'

GO

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'DefaultLog', REG_SZ, N'D:\MSSQL.1\MSSQL\LOG'

GO

Do you see failed logons for "NT AUTHORITY\ANONYMOUS LOGON" on the SSAS server? Does the linked server happen to work in an RDP session on the SQL Server?

If I'm understanding you correctly, your just looking for a way to manage a SSRS subscription from another job. You can create a subscription in SSRS, disable the job it...

You can wrap this in a cursor using dynamic SQL to make it easier for the 75 + logins 🙂

USE master

GO

GRANT VIEW SERVER STATE TO [SomeUserAccount]

GO

You need to enable delegation for the host running the SSIS service for kerberos authentication to work correctly. Also, verify SPN(s), etc. For more information, refer to the following MS...

Looks like there is a lock on the file (on the server, right-click my computer, manager, system tools, shared folders, open files). Also, have you granted permissions to the share...

Just for clarification - you don't create an A record for the SQL instance - just the virtual server name - if this is an active/active there should only be...

K - just let them know you need an A record in DNS for your new virtual server (i.e. MyNewSQLServerName).

Have a good Holiday 🙂