default database

I using the copy database wizard to copy databases from one server to
another. When I copy a db to the new server, it changes the default db
setting for all the users of that db to 'master'. Am I not running the
wizard correctly?
If this is how it works, how do I reset the setting to the db name I want?
I can do it manually but I have atleat 5 databases I have to copy and each
has a lot of users.Look up sp_defaultdb in Books Online.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"sql" <sql@.discussions.microsoft.com> wrote in message
news:F2413537-6302-4194-9D7E-4AEBCFBE28F4@.microsoft.com...
> I using the copy database wizard to copy databases from one server to
> another. When I copy a db to the new server, it changes the default db
> setting for all the users of that db to 'master'. Am I not running the
> wizard correctly?
> If this is how it works, how do I reset the setting to the db name I want?
> I can do it manually but I have atleat 5 databases I have to copy and each
> has a lot of users.

Default Backup Location

Hi

I am almost ashamed to ask but I cannot find the setting

Is there a way to set the default backup location in sql 2005? I dont want to change the folder every time I specify a new media.

Thanks

Alex

Hi Alex,

I don't think you can do it with the SSMS. Here's a registry key you can modify, however:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\BackupDirectory

Regards,
Jake Marx

|||

I suggest that you do not use the default setting in SQL Server (even if you change it) as it makes administration and maintenance more of a headache for (us) DBAs

Come up with a standard approach suitable for your organization on doing backups of databases

Default Allocation Size

In setting up the Data directory for SQL 2000 Im at at the
format partition. The default partition size is
recommended for general use but it says it depends on the
size of the disk.
We are connected to a SAN that is set to 64k stripe set.
Do we need to also set the format of the partition to the
same 64k or will default take care of that (my thinking).
Rob Thiebeau64k is good... you will be fine.!
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rob Thiebeau" <anonymous@.discussions.microsoft.com> wrote in message
news:0afa01c3db7b$3bbf50c0$a501280a@.phx.gbl...

quote:

---

> In setting up the Data directory for SQL 2000 Im at at the
> format partition. The default partition size is
> recommended for general use but it says it depends on the
> size of the disk.
> We are connected to a SAN that is set to 64k stripe set.
> Do we need to also set the format of the partition to the
> same 64k or will default take care of that (my thinking).
> Rob Thiebeau

---

Default Allocation Size

In setting up the Data directory for SQL 2000 Im at at the
format partition. The default partition size is
recommended for general use but it says it depends on the
size of the disk.
We are connected to a SAN that is set to 64k stripe set.
Do we need to also set the format of the partition to the
same 64k or will default take care of that (my thinking).
Rob Thiebeau64k is good... you will be fine.!
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rob Thiebeau" <anonymous@.discussions.microsoft.com> wrote in message
news:0afa01c3db7b$3bbf50c0$a501280a@.phx.gbl...
> In setting up the Data directory for SQL 2000 Im at at the
> format partition. The default partition size is
> recommended for general use but it says it depends on the
> size of the disk.
> We are connected to a SAN that is set to 64k stripe set.
> Do we need to also set the format of the partition to the
> same 64k or will default take care of that (my thinking).
> Rob Thiebeausql

debugging in SSIS

I have a script task in SSIS package. I want to debug the code . but even after setting break points control does not go through the code. So am using msgbox for debuggin purpose ( but its really painfull) can anybody guide me on this.

Thanks,

Prash

first I suggest posting to the SSIS forum

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=80&SiteID=1

Second, this absolutely should be working.

With the VSA designer opened, f9 to set a breakpoint on some code.

when the package executes (from within the design environment, executing outside the designer will not bring up a jit type debugger) the breakpoint should hit.

If you continue to see this problem, post to the SSIS forum to see if anyone can think of things to try.

|||Moving to the right forum|||

prashant550806 wrote:

I have a script task in SSIS package. I want to debug the code . but even after setting break points control does not go through the code. So am using msgbox for debuggin purpose ( but its really painfull) can anybody guide me on this.

Thanks,

Prash

It isn't possible at the moment.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=359859&SiteID=1|||Just a minor point of clarification - you can debug script tasks (in the Control Flow), but you can't debug script components (in the Data Flow). I'm guessing from your problem that you are trying to debug a script component, not a script task.|||

I have tried both script task in control flow as well as script component in data flow but wasnt successful

regards,

Prash

|||

its pitty that SSIS does not support debug mode in script component/task...

Prash

|||

Phil Brammer wrote:

prashant550806 wrote:

I have a script task in SSIS package. I want to debug the code . but even after setting break points control does not go through the code. So am using msgbox for debuggin purpose ( but its really painfull) can anybody guide me on this.

Thanks,

Prash

It isn't possible at the moment.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=359859&SiteID=1

Phil,

That's not true. It is not possible to debug script components but it IS possible to debug script tasks - which is what the original poster said he wanted to do.

-Jamie

|||

prashant550806 wrote:

its pitty that SSIS does not support debug mode in script component/task...

Prash

It does. You CAN debug script tasks - as is stated elsewhere in this thread.

-Jamie

Debug output no longer displaying?

I must have hit some setting to turn off the debug output, but I can't find how to get it back on. The debug output window displays when I execute a package, I just don't get the execution output I had been getting. Sorry to bother you with such trivia, but any help you can provide is appreciated. Thanks.

If I understand you correctly, then what you are looking for is under 'View - Output'.

Pipo

|||That's what I am looking at, but the output window is empty - nothing is being generated in the window when I execute the package. It had been before - just not anymore.|||Got it. When I right click within the output window the option for program output was not checked. When I clicked on that option to set the check on, I then began to get the output trace again.