Viewing 15 posts - 16 through 30 (of 53 total)
We change the Owner of all our Maintenance Plan jobs to "sa". This works whether the the instance is "Windows Only" or "Mixed Mode". We did this to...
June 11, 2013 at 6:12 am
Can use sp_MSForEachDB, like below, to get results from each database on an instance.
EXEC sp_MSForEachDB 'select members.name AS UserName, RTRIM(LTRIM(roles.name)) AS RoleName
from sys.database_principals members
inner join sys.database_role_members drm
on members.principal_id = drm.member_principal_id
inner...
May 22, 2013 at 8:05 am
Sorry. Missed your comment about Import. Have not copied objects between servers using SQL script. Normally use SSIS. What your looking to do could possibly be...
May 15, 2013 at 7:44 am
By having the log backups every hour you are saying you can live with the loss of up to an hour of data. If this is not acceptable to...
May 15, 2013 at 7:32 am
Can use Export. Right click on the source database, then Tasks>Export Data...
May 15, 2013 at 7:22 am
Need to use the reportserver url of the SSRS you want to connect to. May look like http://<server>/reportserver or https://<server>/reportserver or whatever it was configured...
May 14, 2013 at 12:25 pm
We started off with all on one server because of limited use. will revisit in future if it starts to get used more heavily.
John
April 30, 2013 at 12:23 pm
April 30, 2013 at 11:49 am
Can run either way, but when I am debugging something I always run from command line to get messages. Be sure you are looking at the right hi.txt file....
April 24, 2013 at 7:05 am
Hi.
I believe you want to use SQLCMD instead of OSQL. I do not see a -v option for OSQL, but there is one in SQLCMD. I ran the...
April 24, 2013 at 6:16 am
the copy wizard will create an SSIS package with a Transfer Database Task. Because of the nature of the Transfer Database Task, there will be some downtime on the...
April 23, 2013 at 12:09 pm
Hi Donna.
One option is to create a SSIS package and use a Transfer Task such as "Transfer Database Task" or "Transfer SQL Server Objects Task". We use the latter...
April 23, 2013 at 11:58 am
Generally have gotten this message when the Oracle database was unavailable. Check that it is available. Also check firewalls.
Can create a .udl file (i.e. test.udl) and...
April 16, 2013 at 9:39 am
Yes I realized that right after I posted it. I searched around some more but havent found anything. You can use that as your argument that "Microsoft does...
April 9, 2013 at 12:18 pm
Viewing 15 posts - 16 through 30 (of 53 total)