A database with 1 mdf and 2 ldf has been detached from SQL Server 7.0 . Then removed the log files ( they are gone , unable to recover ) and there's no backup at all . Now I want to attach the database with the same mdf , but got error msg - 'Device activation error'. It seems like it's looking for one of the log files.
Is there any way to recover the db ?
I guess NOT , isn't it ?
I don't understand why it doesn't work with sp_attach_single_file_db and sp_attach_db . I actually tested it with a dummy database with 1 log file , and it worked - a new log file was recreated. Thus I performed in production server. Don't understand why it doesn't work.
An attempt to attach an auto-named database for file C:WebApp_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. My web.config file, the connection strings <connectionStrings> <add name="POAdatabaseConnectionString1" connectionString="Data Source=sss;Persist Security Info=True;Initial Catalog=POAdatabase.mdf;Integrated Security=SSPI" providerName="System.Data.SqlClient" /> </connectionStrings> I cann't really find the statement for attaching aspnetdb.mdf. I don't where to find it. Is there any other web.config file in the C drive? Thanks for help!
Hi all I've written an app using VWDE and SSE 2005 but it wont work on my hosts. I'm sure the connection string is correct and my hosts say it's all setup ok over there. I get this message: The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file. And my hosts says that the db should be fine but some of the VB might not work, this is the line that's causing the issues (red): Line 15: Session("username") = loggedInNameLine 16: Line 17: a = Roles.GetRolesForUser(loggedInName)Line 18: Line 19: For Each j In aThis works fine in SSE 2005, should it work on SQL Server too? Can anyone suggest an alternative? ThanksMark
Hello all,I am a total newbie to SQL. I created this sp and then with C++,called it. My return value was 100 (which it was)CREATE PROCEDURE sp_StoreIPs@IPSource varchar(16),@IPTarget varchar(16),@TimeDate varchar(20),@Name varchar(250)asdeclare @iReturn intSet @iReturn = 100return @iReturnGOThen when I added a INSERT statement like ...CREATE PROCEDURE sp_StoreIPs@IPSource varchar(16),@IPTarget varchar(16),@TimeDate varchar(20),@Name varchar(250)asdeclare @iReturn intInsert into LookUP (IPSource, IPTarget,TimeDate, Name) Values(@IPSource,@IPTarget,@TimeDate,@Name)Set @iReturn = 100return @iReturnGOMy return value was 0. I am assuming the the INSERT statement isreturning the 0 but how can I get around this?ThanksRalph Kraussewww.consiliumsoft.comUse the START button? Then you need CSFastRunII...A new kind of application launcher integrated in the taskbar!ScreenShot - http://www.consiliumsoft.com/ScreenShot.jpg
after we download sp1 and hit runj, we got "Unspecific Error Occur" popup window, with message:The following unexpected error occur:" then without any detail. here is the hotfix log:
1) SQL server is running and I can access all the dbs when on the server.
2) All the workstations login to the server just fine. Server is configured for Active Directory.
3) SQL server has only the default instance installed and is in mixed authentication mode.
4) I have registered SQL Server in the Active Directory, (right click on the server node in the SQL Server Enterprise Manager and select the Properties item from the popup menu … Active Directory tab etc - as per the article "SQL Server 2000 Active Directory Integration”.
5) When in EM on the workstation, I try to create a sql server registration
a) With Windows authentication - but I get this error: SQL server registration failed because of the connection failure displayed below. Do you wish to register anyway?
Login failed for user '(null)'. Reason: Not associated with a trusted SQL server connection.
b) With user = sa and pwd = sa (both are the correct values and case) SQL server registration failed because of the connection failure displayed below. Do you wish to register anyway?
Login failed for user 'sa'
5) I have checked out http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B269587 and done everything it says.
Help - I haven't been able to connect for several days.
I have tried deleting the registrations several times - same results. I have tried uninstalling sql 2K and reinstalling 3x and tested before and after installing sp3a - same results.
I have been asked to see what I can recover from a development server whose database became suspect during a power failure.
One developer from another group who's time is limited tried to repair the database using checkdb, but it is still suspect.
There are no recent backups of anything whatsoever. Needless to say, we are lacking in DBA skills here. At this point, we don't care whether we get the data back, but we are desperate to recover the table definitions, user-defined functions and stored procedures -- if not all of them than most of them; if not most of them than some.
What are our options here?
Are their any good third-party tools to help us with this problem?
So im trying to return everything that uses that dbo.style im getting this error I just want to show where that table is being used and suggestions. I know that feature is undocumented. This also doesnt seem to be searching all the Databases when I search it.
Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'master'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'tempdb'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'msdb'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'GoldMine_Sales_and_Marketing'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'CustomerConcerns'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'Aggregate'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'OLD_BUDGET'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'CreditCardData'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'DELSA'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'COZUM'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'DelSolNet'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'DelSolNet2'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'DYNAMICS'. Object does not reference any object, and no objects reference it. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'HUNTB'. In the current database, the specified object is referenced by the following: Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'MASDEV'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'MASDEVSmall'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'OLDOnlineOrdering'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'OnlineRMA'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'OnlineStore'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'DELSO'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'Reporting'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'SSE'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'STTHO'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'TMPLT'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'WHAVL'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'QSCHQ'. In the current database, the specified object is referenced by the following: In the current database, the specified object is referenced by the following: In the current database, the specified object is referenced by the following: Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'SOLKD_DATA'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'SOLKD_NET'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'ALOHA_DATA'. Server: Msg 15009, Level 16, State 1, Procedure sp_depends, Line 28 The object 'dbo.style' does not exist in database 'ALOHA_NET'.
've installed sql 2005 xpress with advanced services......also installed the toolkit that came along..
all 'm interested in is to perform certain data mining operations on the adventureworks db..
;ve also installed the advn works db.........
now here is the prob.......
jus like how the sql online book instructed me i first started off with the datamining tutorial..where i was told to first OPEN BIDS select new PROJECT then make sure that the analysis Services template was selected and then go ahead with selection of the particular sln file....
the problem is that I DON'T SEE ANY ANALYSIS SERVICE TEMPLATE....all i c is a REPORT template..
i really need help guys..... 'm new to .net really feeling helpless...
Hello I have this data in a Access DB of ~4500 posts. Here is a sample of my problem. The Name has no ID, it is a simple text field with ~1800 diferent names in it: Year|Name| ------------------- 2005|NN| 2005|NN| 2005|YY| 2005|XX| 2006|XX| 2006|XX| 2006|XX| 2006|NN| 2006|NN| 2008|NN| 2008|NN| 2008|NN|
I have tried to make a SQL query to show this: Count of each Name Grouped by year
1)Which statement shows the maximum salary paid in each job category of each department?_______ A. select dept_id, job_cat,max(salary) from employees where salary > max(salary); B. select dept_id, job_cat,max(salary) from employees group by dept_id,job_cat; C. select dept_id, job_cat,max(salary) from employees; D. select dept_id, job_cat,max(salary) from employees group by dept_id; E. select dept_id, job_cat,max(salary) from employees group by dept_id,job_cat,salary;
2)description of the students table: sid_id number start_date date end_date date which two function are valid on the start_date column?_________¡£ A. sum(start_date) B. avg(start_date) C. count(start_date) D. avg(start_date,end_date) E. min(start_date) F. maximum(start_date)
Hi All,I am close before throwing the machine out of the window.I tried to establish a linked server on our SQL2000 server pointing to a DB.EXEC sp_addlinkedserver@server = 'DB2',@srvproduct = 'IBM OLE DB Provider for DB2 Servers',@provider = 'IBMDADB2',@provstr='DSN=JDE_PROD;UID=XXXX;PWD=XXX;DATABASE=J DE_PROD;'EXEC sp_addlinkedsrvlogin 'DB2', false, NULL, 'XXX', 'XXXX'If I query the LS using query analyzer or the Enterprise Manager both startto hang, never responding again.To be honest I am quite new to this topic but I read a lot and also tried alot ;)Some articles talk about SNA Servers to be installed first, others aboutsome client tools.I am confused by now...Could anybody please be so kind and tell me how to connect the DB2 as alinked server?Is my statement wrong, and if so how should it look like? Why does theapplication start to hang? Do I really need to install additional softwareto do so?Our DB2 expert also taked about software necessary to access the DB2mainframe. Any ideas?Thanks a lot in advance and belive me, any hints are highly appreciated ;)Seize the DayAndyAndreas BretlJoin Bytes!
After try and error for several months, finally my SQL2000 LS works.
i gave my self a little celebration for that.
but after running well for a day, just one day !
this morning it give me Out of Sync.
error messages:
failure /4305
activity : Load
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4305: [Microsoft][ODBC SQL Server Driver][SQL Server]The log in this backup set begins at LSN 7000000026200001, which is too late to apply to the database. An earlier log backup that includes LSN 6000000015100001 can be restored. [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating abnormally.
activity : Copy
failure / 32
The process cannot access the file because it is being used by another process.
i just dont understand, how come the load & copy process failed, after it works for a day.
Technically i am a network administrator, and know very little about SQL 2005, but it has come under my responsibility to manage this box and a lot depends on fixing this problem for me.
Error:
Service Broker needs to access the master key in the database 'Prototype'. Error code:25. The master key has to exist and the service master key encryption is required.
Also, i get the following both in windows event viewer and SQL logs;
Error:
Source: Logon
Message
Error: 18456, Severity: 14, State: 5.
Login failed for user 'logadmin'. [CLIENT: 192.168.1.2] Event ID 18456;
Login failed for user 'admin'. [CLIENT: 192.168.1.34] Event ID 18456
Symptoms:
While users are working and try to run a new query, their credentials are not accepted anymore. The account they are using is has "sysadmin" rights.
Once they restart the machine, they can run multiple queries, and then the same thign over again.
Please help me with this one, for i have pretty much exhausted google etc. I mean there are various blogs with same prblem but not a straighforward fix.
Hello all, I have 2 primary key fields the ssn and refnum... if the data in the file is duplicated it will not import to my table rights even though i am using DTS to do my import, correct? or do I need to add an extra validator in there?
I would like to pull some data from a SQLServer database, and save it into an Access MDB file (which can be empty to start). I would then zip up the MDB and download it to the user.
I am seeking advice on the most "elegant" or "efficient" way to do this. Here are some ideas I have been considering:
1) Should I start with an empty template MDB and file-copy it before I populate it? Or is there a neat way in ASP.NET to allocate a brand new MDB outright?
2) I could read the SQLServer data into a Dataset object. I could then open a connection to the MDB, create a table object, defining all the columns, etc., and then I could write the data to the new table object. BUT ... I have a hunch there is a nifty ADO.NET way to save the data already in the Dataset object right into the MDB (creating the table and columns as a matter of course) ... all with an instruction or two (or three). Any ideas?
There is a big table with several million records. I am developing a query that retrieve the first rowset that meets WHERE condition. Any suggestions for the fast query? Thanks a lot.
Hello, I am asking a question i have seen many threads on, but I am looking for an idiot's guide on how to convert my SQL 2005 database to SQL 2000 so i can get it to run on my web hosting server. I'm very new to asp.net , but have ahd years of experience in normal HTML and a year or two in the old ASP. I was advised to learn ASP.Net 2.0 and have found it nothing but brilliant. The intergration with SQL 2005 made it a lot quicker to link up a database than using Access. Unfortunatly my hosting company is a little behind and still using SQL 2000. There isn't mch databse intergration (a few aplication forms) so I dont mind re-writing the whole database but I dont know how to set Visual web developer up with a SQL 2000 Database. I have also read from various other forums that you can convert a databse to 2000 by doing something with the scripts, but the explaination is too complicated for me to follow. Is there anyone out there who wouldn't mind going over some old ground and explain this all in simple terms? Im using 'SQL Server Managment Studio Express' (although i dont know how to use it) and 'Microsoft visual web developer 2005 express edition' . Thanks for reading this
Hello all, I'm new to SSIS and this forum, and this is my first post.
We're migrating a 2000 DTS ETL process to 2005 SSIS. We really like the enhanced functionality of SSIS thus far.
One problem we have with our 2000 process is that runs at 1:00am each morning. The scheduling is done via a distributed scheduling tool called Maestro. Our process pulls data from a mainframe-based DB2 OLTP and reformats it into SQL Server reporting tables. We have nightly mainframe batch processing that updates the DB2 tables, and we need those updates on a nightly basis.
The mainframe batch process starts at 8:00pm each evening. It finishes normally by 1:00am 90% of the time, but it is 20+ years old, and has its share of problems, especially during month-end. The problems can't be resolved until the next business day in some cases.
We'd like to elegantly connect the two processes somehow so the SSIS ETL process kicks off when the mainframe batch process finishes. I intentionally didn't use the word 'trigger' up until this point.
It would not be a problem to modify the mainframe batch process to insert or update a DB2 table that SSIS has access to, but I don't think we can get the mainframe batch process to update SQL Server 2005 tables...?
Site A Db1 has to perform transaction replication to Site A- Db2 and Site B- Db1 and Db2.
I started Site A as pubisher and distributor and Site A and Site B both as subscriber.
Site B is in a different geographical area (state).
----------
Please suggest the best scenario to save bandwidth and server load for Publisher, and Distributor.
-------
Earlier I thought that I will implement local replication between Site B - in between Db1 and Db2. The Sql Server does not let me set Db1 as publisher, and distributor for its local database Db2.
-------
P.S. My all databases need same transactions though they are connected to different hardware at different places. So please don't question that why I need four similar databases.
I hope anyone can help me with this. I am having problems connecting to the aspnet database. It all started when I noticed that I could not log in to my webapplication anymore under debug mode, although I was able to log in when remotely accessing the website. I got the error message that the machineaspnet user did not have access to the database: "Login failed for user 'GM-FEDORSASPNET' "This was highly peculiar and rather annoying so I tried several things to straighten this out, but it only made things worse!I read that this had to with permissions of the database in question, al though I could not understand why permissions suddenly had changed. I tried to change the rights by attaching it to Management Studio Express and defining an aspnet login, but that failed because a login under that name was not accepted. I tried to make a copy of aspnet.mdf, delete the original and rename the copy to aspnet.mdf. When that didn't work, I then deleted the aspnet.mdf, counting on it that it would be regenerated automatically, but alas. I located the aspnet_regsql.exe tool to regenerate the database, but got the following error message: System.Web.HttpException: Unable to connect to SQL Server database. ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)What can I do?
Hello everyone, I am upgrading from SQL Server 2000 to SQL Server 2005. Any caveats? Can I just detach the db's and attach them into 2005. Or is there any conversion I should run or import first?
Good morning all. I need some help with a stored proc that is driving me up a wall. It's probably something stairing me right in the face but I can't see it!
I keep getting the following error on the procedure that I'm working on: SQL-DMO (ODBC SQLSTATE: 42000) ERROR 156: Incorrect syntax near keyword 'AS' Must declare the variable '@signid' Must declare the variable '@signid'
Here's the code:
CREATE PROCEDURE [dbo].[ws_savesignature2db] @xml as text='', @image as image='', @imageformat as varchar(20)='', @imagename as varchar(40)='', @imagesize as int=0, AS insert into signaturetable ([image], imageformat, imagename, imagesize) values (@image, @imageformat,@imagename,@imagesize)
/* if your XML field datatype is Text or nTEXT, use the code below in Sql Server 2000. If you use Sql Server 2005, you can use varchar(max) or nvarchar(max) which will be much easier and you do not need the code. */ select @signid = @@IDENTITY DECLARE @ptrval binary(16) SELECT @ptrval = TEXTPTR([xml]) FROM ws_signature WHERE signid= @signid if @ptrval is not null WRITETEXT ws_signature.xml @ptrval @xml GO
In desperate need of implementing a solution where the customer has purchased a CMS to replace their corporate site and wants to use MSSQL as the DB server type. I have 3 servers allocated to me to complete this and I could use some advice on the best setup. THey're running windows 2003 standard server along with sql 2000 standard server. The intended plan is for the 2 servers to become web servers with the last server becoming the sql server. The CMS will reside soley on the sql server and the content for the web site on the seb server(s). What I need to know is if it's possible to set up an active/passive node to accommadate this using the items mentioned above? From what I've been reading sql 2000 enterprise does clustering but I'm hoping this version of sql can be used for something. Any responses are appreciated.
Hi,I am seeking the help of volunteers to test some software that I'vedeveloped which facilitates distributed two-phase commit transactions,encompassing any resource manager (e.g. SQL/Server or Oracle) controlled byMicrosoft's Distributed Transaction Coordinator in a Windows2000environment, with any resource manager under the control of DECdtm (e.g. Rdb(or Oracle via the XA Veneer)) in a VMS environment.[Yes, at some stage, I hope to sell this software and make money out of it,so unless you have a large philanthropic streak or are simply a techie wholikes to stay on top of Windows<->VMS connectivity issues, then you may wishto look away now. But if you do choose to participate, then rest assuredthat I have no interest in your personal or company details. (Just yourwork-rate :-)]What differentiates my Transaction Manager software from existingTransaction Monitor packages that are already in the marketplace (and whyyou should be interested) is that it is based on the Transaction InternetProtocol TIP standard. (RFC 2372) For those of you who don't know, thebeauty of TIP's "Two-Pipe" strategy is it's application-pipe (or middleware)neutrality. Whereas most XA implementations mandate homogenous TransactionMonitor deployments (such as Tuxedo everywhere, Encina everywhere, MQSerieseverywhere, ACMSxp everywhere and so on . . .), hotTIP from TIER3 Softwaregives you complete freedom to choose the middleware product(s) that bestsuite your particular application and heterogeneous network needs.Would you like to talk to VMS with TIER3 Sockets, COM or DCE/RPC? BEAMessageQ, IBM MQSeries or HTML? The choice is yours and yours alone. Butonce you realize that you need to encase your critical transactions withinthe ACID properties of a true Heterogeneous Two-Phase Commit then you willcome to the conclusion that you need a Transaction Manager that looks a lotlike this.Another drawback of traditional "One-Pipe" strategies is that they precludethe run-time determination of transaction participants. (Functionalitywhich may be advantageous in a wide-area or Internet based application.)Anyway, this is what I have: -On the Windows side, you need absolutely *NO* additional software! I'llreply to this note with a brief description of the COM+ and DTC functionsthat you would need to invoke in order to successfully push a MTS/DTCtransaction to VMS. NB: These are standard Windows APIs that are fullydocumented on MSDN.On the VMS side, I have a VMSINSTAL saveset that (all zipped up) is some150KB that I'm happy to e-mail to you along similar lines to the VMShobbyists (non-commercial use) license. I'll reply to this note with anInternet Daemon (INETd) example of code that uses my software to cedetransactional control, over an SQL insert into a Rdb database, to MTS/DTC.It's under 500 lines long and contains all of the DCL, 3GL, SQL required toproduce a working example of a TIP-2PC capable TCP/IP auxiliary server. Thisexample will insert a row into the MF_PERSONNEL.Employees table on the VMSside in co-operation with Windows2000 MTS/DTC client that is inserting a rowinto the NORTHWIND.Employee table. Commit them all or roll them all back.So, in summary, If you'd like to volunteer to put hotTIP through it's pacesthen simply reply to this mail.Regards Richard MaherPS. The following are a few functionality restrictions with the currentversion of my software that may effect your decision to participate: -1) Transaction has to be started/mastered/coordinated by W2K MTS/DTC2) Transactions cannot be PULLed from VMS and must be PUSHed from W2K3) No cluster-wide recovery.(If a txn falls over after being prepared then you have to wait for thatspecific node to become contactable again even though that lovely RDMrecovery job is sitting on another node protecting the database until myhotTIP TM tells it to commit or abort.)4) There is currently no Alpha or Itanium version available. The Alpha portis currently in progress but, for the time being, you'll either need a VAXor a VAX emulator on your PC.
I read somewhere that market basket analysis finds rules with substitutes as likely as rules with complements due to a consumer behavior called "horizontal variety seeking". This is when customers buy more than one product in the same category even though they are subsitutes. For example, when people go to the grocery store and buy soda, they buy coke and sprite at the same time even though they are substitutes of each other. I was wondering if anyone has experience with this anomaly and how they solved it. I found a time series model called the vector autoregressive model which is used to find the elasticity of prices over a time period. Does anyone have experience working with the VAR model? I am having trouble figuring out what some of the variables in the model are.
Hi. We've decided to convert our Crystal Reports to SSRS 2005. We know (thanks to this forum) there are companies that will convert the reports at a cost; however, we'd like to undertake this ourselves. Are there resources you can point us to that might be specific for Crystal Reports users coming over to SSRS, especially for newbies? Thank you.
I'm a complete newbie. Need to insert a Company logo into a databasecolumn to use later on in a check printing application. Read how toinsert the pointer instead of the object into the column. Below iswhat I did:SET QUOTED_IDENTIFIER OFFGOINSERT INTO BankInfo(CoLogo) VALUES(0xFFFFFFFF)***Then I did this****DECLARE @Pointer_Value varbinary(16)Select @Pointer_Value = TEXTPTR(CoLogo)FROM BankInfoWHERE CMCo = '91'WRITETEXT BankInfo.CoLogo @Pointer_Value"\192.31.82.77DataCheckImagesWyattLogo.jpg"****This was straight out of a book and it seemed to work it gave me amessage that it was successful and when I view the data in the columnI can see the pointer0x453A5C436865636B496D616765735C57796174744C6F676F 2E6A7067*****But when I try to use the column in either Crytal Report or an AccessReport the Bank Logo does not show up. I also placed the logo on my Cdrive and tried pointing to it there with "C:WyattLogo.jpg" with nosuccess.It can't be this difficult to get a Company logo into a column. Idesperately need assistance. Remember I am the ultimate newbie. Ilooked at my first sql database last week. Thanks in advance for anyhelp, it is appreciated.
I own a DELL dimesnsion 4600 desktop. I purchased it with windows xp HOME although I have upgraded to windows xp professional. I am trying to install Office Enterprise 2007 with the disk i purchased. My computer will not pick it up though. I know the cd works because I tried it on another computer but didnt intsall it. That computer read the disk. My computer will not. any help? desperate need
Hello,I've been searching the web for quite some time to resolve the problemof "1/1/1900" returning in a datetime field in SQL that resulted from ablank (not NULL) value being passed to it through an ASP page.The solution is that a NULL value needs to passed to SQL from ASP.Thats fine...I understand the why the problem is happening and thesolution around it. HOWEVER, I can't seem to get the proper syntax towork in the ASP page. It seems no matter what I try the "1/1/1900"still results. Below are a few variations of the code that I havetried, with the key part being the first section. Does anyone have anysuggestions?!?!?______________cDateClosed = ""If(Request.Form("dateClosed")= "") ThencDateClosed = (NULL)end ifsql="UPDATE rfa SET "&_"dateClosed='"& cDateClosed &"', "&_"where rfaId='"& Request.Form("RFAID")&"'"_____________________________cDateClosed = ""If(Request.Form("dateClosed") <> "") ThencDateClosed = (NULL)end ifsql="UPDATE rfa SET "&_"dateClosed='"& cDateClosed &"', "&_"where rfaId='"& Request.Form("RFAID")&"'"_____________________________cDateClosed = ""If(Request.Form("dateClosed")= "") ThencDateClosed = NULLend ifsql="UPDATE rfa SET "&_"dateClosed='"& cDateClosed &"', "&_"where rfaId='"& Request.Form("RFAID")&"'"_______________Thanks in advance!!!!
I'm trying to ascertain how I can find out more about a particular job.
The information I have from a script I have to identify deadlock root causes gave me back this information: spid 86 is blocking spid 51... spid 86 info: SQLAgent - TSQL JobStep (Job 0xBAD836E3D331B44BA4CCAC400D244B17 : Step 1)
Well, that's good to know, but I would like to be able to identify the particular job that 'owns' TSQL JobStep (Job 0xBAD836E3D331B44BA4CCAC400D244B17 : Step 1).
I've read the BOL on the sysjob type tables; and, while they tell me about the columns in the tables and what they are, they tell me absolutely nothing about how one goes about figureing out what I want to know.
I suspect one problem I have is that '0xBAD836E3D331B44BA4CCAC400D244B17' needs converting to something else and I have no idea how to go about doing this. I was never that good at converting hex (I assume that is what this is) when I was doing it rather often, which is years ago, so I really have no idea how to start.
Does anyone have any basic, simple scripts of sp's that I can give mycomputer operators to use to monitor for serious conditions on our sqlservers? We are new in the ms-sql arena, a small shop and we cantreally purchase any tools to monitor these servers, but we need somebasic checks that we can use to make sure a server is performing in areasonable fashion, no blocks, cpu<xx%, memory not pegged, IO working,etc...and we need to be able to do this without bugging ourprogrammers every time we are wondering why things are slowwnig down.We are a split shop between as400s and sql servers, and our operationsstaff has no problem performing this type of duty on the 400s. I thinksince the sql servers are so easy to deploy into production, the ideaof how to monitor these things health got lost in the shuffle andallowing the programmers to do it just serves to destabilize ourenvironment.Please help! Our shop has turned to chaos since we went live withMSSQL centric applications and everytime one programmer "resolves anissue" some other programmers application starts to act up.
