this looks like it's from an EDI file, and the problem with EDI, is fields are optional...i doubt very much that your file has exactly four fields through the whole...

can you try explicitly using a datetime variable? i'm wondering if it's the implicit conversion of a string to datetime that is the issue:

select a.* b.description

from sqlservertable a

left outer join

oracleparttable...

take a look at this thread for some high performance strip-non-numeric functions.

you would need to change it so that it also allows dashes, but that's a trivial tweak:

do you have...

either remove the paramter, or reassign it to the new value and ignore whatever is passed:

--ignore whatever was passed, and get the desired top

ALTER PROCEDURE psGetInformationByProduct_Andrei

@col1 int,@top int

AS

BEGIN

SELECT @top =...

sysinternals psexec can do it, so you could issue the net stop mssqlserver command against a remote server, but under what circmstances would you need to bounce the service?

your not...

you'd do this in a programming language. but, if you really wanna do it in TSQL...keep reading....

the only way to do it is via CLR, because SQL, natively, does not...

on my servers, for example, the only extended stored procs are those that were isntalled when i deployed Redgate SQL Backup.

Like Gail said, other than a vendor that i'm familiar...

the beauty of robocopy is that it checks if the file was already moved/exists/changed;

it doesn't re-copy files that are already exist on the destination folder, which is very nice when...

well, there's a few pieces to this puzzle

1. You had to create a credential for a network user who has permissions

2. you had to create an operator in SQL Agent...

i've got something i'm cosnuming for SQL2008R2 for deadlocks, and comparing it to yours, my item is slightly different:

you have

SELECT XEvent.query('(event/data/value/deadlock)[1]') AS DeadlockGraph

mine has this...no "deadlock" in the XEvent

SELECT...

you will most likely run out of disk space long before you approach the max number of objects.

this is the max for any database, regardless of being a user db,...

search for IsValidEmail here on SQL server Central; there's a few threads that looked into it pretty deeply; there's tsql versions similar to what you are testing, as well as...

i think it's a scope issue.

it looks like technically there are two [myuser] users, in two different databases.

they only get JOINED to be the same person when you use a...

what database are you STARTing in?

select * from dbo.MyTable would fail if you start in master. there's no MyTable in master, regardless of your permissions in MyDatabase

a three part query...

don't know if this helps, but i use a powershell script as a SQL Agent job step, which in turn calls robocopy to copy all my redgate *.sqb files

that job...