That. Or the other part of the error about permissions. What type...

I am uncertain why you are still getting incorrect results. What is your server collation?

select serverproperty('collation')

if you don't change max memory setting , 2147483647(2 petabytes) is what it is set to out of the box.

if you leave it at this setting (not recommended) sql...

max memory is not limited to the total memory on the server and the highest you CAN set it would be the default of 2147483647. The sql server will just...

try adding the CODEPAGE=RAW argument. This will cause no data conversion to be performed.

declare @file sysname;

SET @file = 'C:\temp\test.txt'

SET nocount ON

CREATE TABLE #tempfile (Column1 varchar(max))

EXEC ('bulk INSERT #tempfile FROM "'+@file+'"...

is the user in sysadmin server role on the 2000 box or is the user dbo (not db_owner role) of database on the 2000 box?

Is this a user defined stored proc or a system one?

the user might be dbo or sysadmin on the 2000 server or the proc might have execute permissions granted in...

jancas08 (2/25/2013)

---

Hi, I need help with this dynamic query to execute the sql statements but it gives the following error when i run it:

UPDATE [janinetestdata].[dbo].[EDTE] set ED_THREE = CORRECTED VALUE...

you could use BCP as well.

BCP "select col1+','+col2+','+col3 from dbo.table" queryout c:\temp\file.csv -c -T

or if you have xp_cmdshell enabled you can run it from SSMS or sql agent(note: xp_cmdshell can...

SQL server 2008 R2 licensing is per processor, not per core SQL Server 2008 r2 Licensing guide. SQL Server 2012 is per core licensing.

As to you question about processor affinity....

I have come across this as well and it seems that the sp_statement_started and sp_statement_completed do not return individual statements within a stored proc. As Lynn suggested, it is in...

try taking the single quotes away from around your parameters

CREATE Procedure [dbo].[SetDefaultDatabase]

@LoginString NVARCHAR(50),

@DatabaseString NVARCHAR(50)

As

Begin

Set NoCount On

Exec sp_defaultdb @loginame=@LoginString, @defdb=@DatabaseString

End

GO

Try running the DTexec command in the command prompt but open the command prompt in the context of the SQL server Service account. On windows 2003/xp you can right-click on...

does the dtexec command work if you manually execute it in command prompt? taking xp_cmdshell out of the equation.

also will this create a file

exec xp_cmdshell 'dir \\server\Folder1\Folder2 > \\server\Folder1\Folder2\test.txt'

What are the results if you do a dir on the folder with xp_cmdshell

exec xp_cmdshell 'dir \\server\Folder1\Folder2'