hello,

can you tell me yf this works when you put this code into ASP page and run from remote location?

This is exactly what i need to run a SSIS job...

uau!

i am reading this:

http://www.w3schools.com/sql/sql_injection.asp

i am feeling like a dunkey!

i am sorry, i understand you, but my english is too bad!!!!

"Your transaction is isolated, changes one person makes can't affect any other, however that's not enough in this case as you don't want two people to read the same row...

Hello,

"

The very first thing you need to do is read up on SQL Injection, because your code is riddled with security vulnerabilities (unless you want your company's data exposed the...

i do it myself....not external enterprise....just to try!

Jg

ok, i agree with all!

"

Probably a good time to impress on management that a good backup would have saved days of work and prevented the loss of that data

"

YES! My...

Hello,

I tried to backup the Db HISTORICO but the error continues.

See attached image and logs from SQL.

I've recover almost all the tables ... some have failed but it is...

"

What do you mean 'mistake'?

"

Error! CRC Error!

------

"

Are the people who gave those 'orders' going to accept responsibility for the loss of this database? Did they understand the consequences of not...

thank you guys!

I have to go though, they are 17:20 (Portugal).

I have two girls waiting for me and still 40 minutes away by train!

Thank you!

JG

Olá,

I tried backing up the DB ... mistake!

I tried to back up files from DB .... mistake!

I tried to shrink the F:\...\xxxxx9.ndf for other files (V:\....\ ...).... mistake!

I am able...

Q1:

the file is in the same filegroup...."Primary"....grrrrrrrrrrrrrrrrrrrr

Q2:

logs....i have lots of messages in windows event log (application and system) and SQL event log.

see attachments....

obrigado,

JG

Hi,

i need to read the file in the internet to my SQL Server directly, like this:

-----------------------------------------

DECLARE @CD TABLE (XMLData XML);

INSERT INTO @CD

SELECT *

FROM OPENROWSET(BULK N'http://www.w3schools.com/XML/cd_catalog.xml', SINGLE_BLOB) rs;

INSERT INTO dbo.CD_Info...

Waine,

I created the stored procedure in a DB "Performance ", with temporary tables (fine!!!), like you said.

Now when I call the stored procedure from this command line:

- exec performance.dbo.sp_BigTablesSP

the...

well ... I'm getting crazy!

I said that temporary tables in stored procedures did not work because when I tried to create a stored procedure with code 1 gave me...