adam kurtz (7/24/2012)

---

Yes - I know, but...

Phil Parkin (7/24/2012)

---

I have, though not enough to pretend that I am particularly adept with them.

But what I meant is that XML files are so flexible in structure that the...

Koen Verbeeck (7/22/2012)

---

Jeff Moden (7/22/2012)

---

Between what I've seen on the forums, in articles, and what I've seen co-workers go through, I'm going to have to chant for about a month...

Does this login ‘MISDOM\SILVONDEMO2$’ has access to both the servers?

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.

ALTER TABLESPACE

http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_3002.htm

Alternatively, if you have...

Lowell (7/20/2012)

---

the Stairways series is a great start:

http://www.sqlservercentral.com/stairway/

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...

duc.nguyen (7/18/2012)

---

Thank you very much for your help!

I do not know how to create the SSIS Package (SSIS / BULK INSERT / BCP).

If possible can you show me how? ...

dbcc inputbuffer(spid)

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...

laddu4700 (7/20/2012)

---

Hi,

litespeed full user db bakcup failed with below error...anyone have any idea. please help

Message

Executed as user: domain\sqlservice. ...CANE' with Windows Authentication Logged on to SQL Server server123 Starting...

In continuation to what Gail said...

Google: Backup, Locking / Blocking & Commit / Rollback.

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.

Jeff Moden (7/14/2012)

---

Dev (7/14/2012)

---

But [font="Arial Black"]considering the security threat involved[/font] in it, we do enable it for a while (couple of milliseconds), execute the command & disable it in sql...

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...

Did you follow this?

Restore Files and Filegroups (SQL Server)

http://msdn.microsoft.com/en-us/library/aa337540

You might need a SSIS / BULK INSERT / BCP scheduled job. Opt as per your convenience.