Adding a schedule to a job requires separate proc calls from adding the job. On the source select from msdb.dbo.sysschedules and from msdb.dbo.sysjobschedules to build the relevant calls to msdb.dbo.sp_add_schedule...

mithunc23 (6/29/2013)

---

Hi All,

I am a newbie to sqlserver.I recently came across "sqlcmd"utility feature while surfing.So here is my doubt.

I connect to a server using some credentials.I do it like

--->Right...

Yep. For oft used snap-ins you can edit your Profile so they are auto-loaded...

The assumption is that you will not have any non-core snap-ins loaded at startup. On my machine:

[font="Courier New"]PS C:\Users\Orlando> Get-Command -commandtype cmdlet | select PSSnapin -Unique

PSSnapIn

--------

Microsoft.PowerShell.Core

PS C:\Users\Orlando> Add-PSSnapin -Name SqlServerProviderSnapin100...

CDC wasn't really built to be an audit tool per se, although it can be used that way if it happens to satisfy your requirements. For you it clearly does...

MSSQL_NOOB (6/27/2013)

---

Thanks for the tip, John.

And OPC, thank you for the link. I was able to run the script on SQL Server 2008. You don't by any chance have a...

MSSQL_NOOB (6/27/2013)

---

Issue Replication:

1) Create Login for user Domain\ABC

2) User Mapping for user Domain\ABC to Database ABCTest (DB User created in ABCTest database)

3) Remove Domain\ABC username from Login

I am still...

Was it a Java app by chance?

Happy to. Forgot about the view fronting the table for bulk loads. That has saved my bacon more than once.

calvo shows the approach I use, namely:

1. Get a PowerShell Object.

2. Convert PowerShell object to a .NET DataTable

3. Load DataTable into a SQL Server table using SqlBulkCopy.

SqlBulkCopy is a .NET...

Cheerleader

@ is acceptable in both SQL Server and Windows passwords. In the case of Windows Authentication, SQL Server will never even be sent the actual password as authentication is offloaded...

erikd (6/25/2013)

---

I'll see if I can figure it out when I have some extra time. I'm most likely going to leave this SP as-is (at least for now), since it's...

erikd (6/25/2013)

---

For the simple file move, I agree with you. But I'm doing a bit more than that with the file name as a variable. I'm not sure I could...

erikd (6/25/2013)

---

opc.three (6/25/2013)

---

Gosh, that seems like a lot of code to move the newest file from one place to another. Here is how you would do the same in PowerShell:

$SourceFileSpec...