HELP! sp or other tool to help diagnose recent record deletion?

I'm trying to trouble shoot an app that after two years of running
more or less fine has suddenly had a problem. An average user was
filling out a web form and clicked save, only to have their entire
multi page report form get obliterated. This user has no delete
rights, and even if they had pressed cancel the ASP page would simply
not write that page...but would not delete the entire series of
records.
I am stepping through ASP code and trying to recreate the problem but
I'm relatively new to SQL and not sure what sytem stored procedures or
functions might help me...records of recent deletes (within the last
few hours), userinfo (who really deleted the record)? Etc.
Coincidentally (perhaps) this server was nearly full (aprox 700 megs
left). I know...this is terrible. I've been harping my sysadmin to get
some non DB related stuff off my SQL server and we cleared a few Gigs
off this morning! Anyway, it's very likely the cause...again...could
someone point me to what logs or functions or documentation I should
be looking at that might help me verify this?
Many thanks!!
This might help you -- these guys have some good tools. I recommend,
though, that you restore the database to another area on the server and
compare the data with some custom queries to see what's missing...
http://www.red-gate.com/products/SQL_Log_Rescue/index.htm?gclid=CK-roqn2mIoCFRyVFQodbFaonQ
mahalie@.gmail.com wrote:
> I'm trying to trouble shoot an app that after two years of running
> more or less fine has suddenly had a problem. An average user was
> filling out a web form and clicked save, only to have their entire
> multi page report form get obliterated. This user has no delete
> rights, and even if they had pressed cancel the ASP page would simply
> not write that page...but would not delete the entire series of
> records.
> I am stepping through ASP code and trying to recreate the problem but
> I'm relatively new to SQL and not sure what sytem stored procedures or
> functions might help me...records of recent deletes (within the last
> few hours), userinfo (who really deleted the record)? Etc.
> Coincidentally (perhaps) this server was nearly full (aprox 700 megs
> left). I know...this is terrible. I've been harping my sysadmin to get
> some non DB related stuff off my SQL server and we cleared a few Gigs
> off this morning! Anyway, it's very likely the cause...again...could
> someone point me to what logs or functions or documentation I should
> be looking at that might help me verify this?
> Many thanks!!
>
-Dave Markle
http://www.markleconsulting.com/blog
sql

HELP! sp or other tool to help diagnose recent record deletion?

I'm trying to trouble shoot an app that after two years of running
more or less fine has suddenly had a problem. An average user was
filling out a web form and clicked save, only to have their entire
multi page report form get obliterated. This user has no delete
rights, and even if they had pressed cancel the ASP page would simply
not write that page...but would not delete the entire series of
records.
I am stepping through ASP code and trying to recreate the problem but
I'm relatively new to SQL and not sure what sytem stored procedures or
functions might help me...records of recent deletes (within the last
few hours), userinfo (who really deleted the record)? Etc.
Coincidentally (perhaps) this server was nearly full (aprox 700 megs
left). I know...this is terrible. I've been harping my sysadmin to get
some non DB related stuff off my SQL server and we cleared a few Gigs
off this morning! Anyway, it's very likely the cause...again...could
someone point me to what logs or functions or documentation I should
be looking at that might help me verify this?
Many thanks!!This might help you -- these guys have some good tools. I recommend,
though, that you restore the database to another area on the server and
compare the data with some custom queries to see what's missing...
http://www.red-gate.com/products/SQL_Log_Rescue/index.htm?gclid=CK-roqn2mIoCFRyVFQodbFaonQ
mahalie@.gmail.com wrote:
> I'm trying to trouble shoot an app that after two years of running
> more or less fine has suddenly had a problem. An average user was
> filling out a web form and clicked save, only to have their entire
> multi page report form get obliterated. This user has no delete
> rights, and even if they had pressed cancel the ASP page would simply
> not write that page...but would not delete the entire series of
> records.
> I am stepping through ASP code and trying to recreate the problem but
> I'm relatively new to SQL and not sure what sytem stored procedures or
> functions might help me...records of recent deletes (within the last
> few hours), userinfo (who really deleted the record)? Etc.
> Coincidentally (perhaps) this server was nearly full (aprox 700 megs
> left). I know...this is terrible. I've been harping my sysadmin to get
> some non DB related stuff off my SQL server and we cleared a few Gigs
> off this morning! Anyway, it's very likely the cause...again...could
> someone point me to what logs or functions or documentation I should
> be looking at that might help me verify this?
> Many thanks!!
>
-Dave Markle
http://www.markleconsulting.com/blog

HELP! sp or other tool to help diagnose recent record deletion?

I'm trying to trouble shoot an app that after two years of running
more or less fine has suddenly had a problem. An average user was
filling out a web form and clicked save, only to have their entire
multi page report form get obliterated. This user has no delete
rights, and even if they had pressed cancel the ASP page would simply
not write that page...but would not delete the entire series of
records.
I am stepping through ASP code and trying to recreate the problem but
I'm relatively new to SQL and not sure what sytem stored procedures or
functions might help me...records of recent deletes (within the last
few hours), userinfo (who really deleted the record)? Etc.
Coincidentally (perhaps) this server was nearly full (aprox 700 megs
left). I know...this is terrible. I've been harping my sysadmin to get
some non DB related stuff off my SQL server and we cleared a few Gigs
off this morning! Anyway, it's very likely the cause...again...could
someone point me to what logs or functions or documentation I should
be looking at that might help me verify this?
Many thanks!!This might help you -- these guys have some good tools. I recommend,
though, that you restore the database to another area on the server and
compare the data with some custom queries to see what's missing...
http://www.red-gate.com/products/SQ...br />
odbFaonQ
mahalie@.gmail.com wrote:
> I'm trying to trouble shoot an app that after two years of running
> more or less fine has suddenly had a problem. An average user was
> filling out a web form and clicked save, only to have their entire
> multi page report form get obliterated. This user has no delete
> rights, and even if they had pressed cancel the ASP page would simply
> not write that page...but would not delete the entire series of
> records.
> I am stepping through ASP code and trying to recreate the problem but
> I'm relatively new to SQL and not sure what sytem stored procedures or
> functions might help me...records of recent deletes (within the last
> few hours), userinfo (who really deleted the record)? Etc.
> Coincidentally (perhaps) this server was nearly full (aprox 700 megs
> left). I know...this is terrible. I've been harping my sysadmin to get
> some non DB related stuff off my SQL server and we cleared a few Gigs
> off this morning! Anyway, it's very likely the cause...again...could
> someone point me to what logs or functions or documentation I should
> be looking at that might help me verify this?
> Many thanks!!
>
-Dave Markle
http://www.markleconsulting.com/blog

Help! I have a VB6/SoapToolkit 3.0/Sql Reports issue.

I am trying to retro fit Sql Reports in my VB6 app. Now i have a dynamic
RDL Generator that assembles the .RDL and writes it out to a file. That
part works fine. The next step I'm getting stuck on is the SOAP part to
deploy it to the reportserver. I have scoured the internet but there isn't
a lot of help out there because everyone is jumping off the VB6 boat, so
here I am. I have this so far:
'Use SOAP API to deploy reports to server
Dim oSoapClient As MSSOAPLib30.SoapClient30
Set oSoapClient = Nothing
Set oSoapClient = New MSSOAPLib30.SoapClient30
Call oSoapClient.MSSoapInit
("http://servername/reportserver/reportservice.asmx?wsdl")
That part executes fine with out error
Now when I start to reference things like oSoapClient.url or
oSoapClient.createdatasource i get "Object doesn't support this property or
method"
Is there something I am leaving out? Am I missing a step?
Any help would be appreciated.
--
Message posted via http://www.sqlmonster.comI have the .NET version of this working perfectly it's just the
VB6/SOAPToolKit 3.0 part that I am getting stuck on.
--
Message posted via http://www.sqlmonster.com|||I have played around with the idea that the SQL 2000 Reporting services
file "reportservice.wsdl" needs to be in the VB6 references somehow. But I
have no idea on how to get in there. If thats a viable option.
--
Message posted via http://www.sqlmonster.com|||anybody have any suggestions?
--
Message posted via http://www.sqlmonster.com

Help! First timer with SQL

I am trying to write my first app using SQL Server. I am not able to even open a connection. I get the following error message:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

I am not sure first of all why the user is listed as null. I hard coded a user name in for test purposes. Second, how DO I establish a trusted connection with a SQL Server. The SQL Server is located on an internal domain controller.

Also, is it necessary to have anything special installed on my remote machine? As I said, I am VERY new to Microsoft SQL ServerCan you post your conn string?|||Sure... here is the connection string. It was generated by default by the system.

data source=ERICSERVER;initial catalog=Northwind;integrated security=SSPI;persist security info=False;workstation id=ERIC;packet size=4096

Any ideas?|||ejcrammer I 2 am also in your shoes. I am new to SQL Server and ASP.NET. I also am trying to connect to a database and am receving the same error message you are. I have looked at your connection string but their does not seem to be one specific way to write the connection string because I have seen about 7 different versions all of which are not good and no one really explains them in detail. some ask for password and username some dont, I dont know. Anyway since were both in the same shoes I was wondering if you figure out this answere to this question you could post and let me know and I as well will post back if I figure out the answere to this problem we seem to be haveing.
Thanks

Help with using integrated security

I am building a reporting aspect of my .NET web app, and I have already come
accross the problem where if the app is hosted on a server and the backend
SQL database is hosted on another server, I cannot use integreated security
to retrieve data from the sql server (unless deligation is turned on...).
Now, our Report server is on a third machine. Can my data source(s) on the
report server use Integrated Authentication? A brief test failed, saying
cannot authorize NT/Anonymous but I may have set something up incorrectly.
Any suggestions?
BenThere is a double hop issue that you might be coming up against. You have to
be using Kerberos to be getting around this. Search the MS site for the
phrase double hop and you should find info on it and can see if it matches
your problem.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ben" <ben_1_ AT hotmail DOT com> wrote in message
news:B7DDBD38-A4FD-4EF2-AAA7-95D0B0478FDD@.microsoft.com...
>I am building a reporting aspect of my .NET web app, and I have already
>come
> accross the problem where if the app is hosted on a server and the backend
> SQL database is hosted on another server, I cannot use integreated
> security
> to retrieve data from the sql server (unless deligation is turned on...).
> Now, our Report server is on a third machine. Can my data source(s) on
> the
> report server use Integrated Authentication? A brief test failed, saying
> cannot authorize NT/Anonymous but I may have set something up incorrectly.
> Any suggestions?
> Ben|||Bruce
Thank you for the reply. I haven't done the search but I guess its the same
problem I'm having with the asp.net app im building.
Its funny, best practises says your db, your app and report server should
all be separate and integrated security used, but this setup doesnt naitively
work with integrated security.
thanks for the help.
"Bruce L-C [MVP]" wrote:
> There is a double hop issue that you might be coming up against. You have to
> be using Kerberos to be getting around this. Search the MS site for the
> phrase double hop and you should find info on it and can see if it matches
> your problem.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ben" <ben_1_ AT hotmail DOT com> wrote in message
> news:B7DDBD38-A4FD-4EF2-AAA7-95D0B0478FDD@.microsoft.com...
> >I am building a reporting aspect of my .NET web app, and I have already
> >come
> > accross the problem where if the app is hosted on a server and the backend
> > SQL database is hosted on another server, I cannot use integreated
> > security
> > to retrieve data from the sql server (unless deligation is turned on...).
> > Now, our Report server is on a third machine. Can my data source(s) on
> > the
> > report server use Integrated Authentication? A brief test failed, saying
> > cannot authorize NT/Anonymous but I may have set something up incorrectly.
> >
> > Any suggestions?
> > Ben
>
>|||You can use delegation, a feature built into 2K3 and AD. See this
link:
http://technet2.microsoft.com/WindowsServer/en/Library/c312ba01-318f-46ca-990e-a597f3c294eb1033.mspx
Bruce L-C [MVP] wrote:
> There is a double hop issue that you might be coming up against. You have to
> be using Kerberos to be getting around this. Search the MS site for the
> phrase double hop and you should find info on it and can see if it matches
> your problem.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ben" <ben_1_ AT hotmail DOT com> wrote in message
> news:B7DDBD38-A4FD-4EF2-AAA7-95D0B0478FDD@.microsoft.com...
> >I am building a reporting aspect of my .NET web app, and I have already
> >come
> > accross the problem where if the app is hosted on a server and the backend
> > SQL database is hosted on another server, I cannot use integreated
> > security
> > to retrieve data from the sql server (unless deligation is turned on...).
> > Now, our Report server is on a third machine. Can my data source(s) on
> > the
> > report server use Integrated Authentication? A brief test failed, saying
> > cannot authorize NT/Anonymous but I may have set something up incorrectly.
> >
> > Any suggestions?
> > Ben