Viewing 15 posts - 1 through 15 (of 2,007 total)
adam kurtz (7/24/2012)
Lynn Pettis (7/24/2012)Not that hard to automate a backup/restore process. There may actually be scripts on this site that can help with this.
Lynn Pettis (7/24/2012)
Yes - I know, but...
July 24, 2012 at 12:15 pm
Phil Parkin (7/24/2012)
But what I meant is that XML files are so flexible in structure that the...
July 24, 2012 at 12:01 pm
Koen Verbeeck (7/22/2012)
Jeff Moden (7/22/2012)
July 24, 2012 at 11:58 am
Does this login ‘MISDOM\SILVONDEMO2$’ has access to both the servers?
July 24, 2012 at 11:37 am
First of All... here is a link to Oracle Documentation for tablespace management commands/syntaxes. It will guide you on how to manage tablespace with command.
Alternatively, if you have...
July 24, 2012 at 11:34 am
there is a LOT of different subjects, and they build up in complexity and understanding as you go through each stairway.
I'd recommend starting...
July 21, 2012 at 9:04 am
I do not know how to create the SSIS Package (SSIS / BULK INSERT / BCP).
If possible can you show me how? ...
July 21, 2012 at 8:56 am
If the above command indicates any cmdshell / bcp execution, kill it from Task Manager. It could be a malicious activity as well.
Be cautious enough, it's your PROD...
July 21, 2012 at 8:49 am
litespeed full user db bakcup failed with below error...anyone have any idea. please help
Executed as user: domain\sqlservice. ...CANE' with Windows Authentication Logged on to SQL Server server123 Starting...
July 21, 2012 at 8:42 am
In continuation to what Gail said...
1.What precautions will you take before updating a million rows in a table in a production database.?
Google: Backup, Locking / Blocking & Commit / Rollback.
July 21, 2012 at 8:39 am
I guess I was not clear on my part. ‘FK_<Child_Table>_<Parent_Table>_<Parent_Column(s)>’ is Foreign Key (Constraint) Name. The FK columns borrow the same name as they have in parent tables.
July 19, 2012 at 11:37 am
Jeff Moden (7/14/2012)
July 18, 2012 at 1:40 am
Do you have a valid login & password to login to SQL Server? Then, do you have sufficient permissions to add New Logins?
If not, please consult DBAs in your...
July 18, 2012 at 1:19 am
Did you follow this?
Restore Files and Filegroups (SQL Server)
July 18, 2012 at 1:11 am
You might need a SSIS / BULK INSERT / BCP scheduled job. Opt as per your convenience.
July 18, 2012 at 1:01 am