Search results for query: *

OK After chasing my tail endlessly and bumping into a plethora of similar posts from similarly lost souls I have decided that its just a waste of time pursuing this. CR is great if you want to print to "standard" paper sizes but rubbish if you want to print to labels on a Zebra thermal printer...

I am stumped. In VB6 I did this LabelToPrint.SetUserPaperSize (5 * 1440 / 2.54), (10.2 * 1440 / 2.54) And all worked well. On conversion to VB 2005 I can only choose from a set list of papersizes when I use .PrintOptions.PaperSize. I have searched endlessly and I think that I have just lost...

Wow. I just found this trick, courtesy of Greg Robidoux ( 3/18/2008 on mssqltips). If you do backups often you may see that the System event log will fill quite quickly with Backup notifications. To STOP this logging you can try this DBCC TRACEON (3226,-1) And to turn it back on DBCC...

Oh boy. Mediapassword <> password!!!!!!! I am an eedjit. Thanks for your time on this

Thanks.

Help!!!! I have a backup that I have created using vb 2005 with a password of "!cp0p#Adm1n1strat0r". Now, when I go to restore it I am told that the password is invalid. I am guessing that it is the "!" and "#" causing problem. any ideas on how I can resolve this? Cheers

Hello ALL I am trying to stop the unauthorised attachment of a database. Yes, I have asked this before and yes ... I am using encryption. But I have become intrigued with tee DDL triggers. In principle I want to detach on attach, as I have scripted below Create Trigger [All_Events] On Database...

Yeah, its sad but poorly implemented networks are a nightmare. In fact network is a poor description for the nightmares that I am encountering. Encryption, here I come. Cheers

OK Back from a forced break. Staff probs. Thanks for your replies. Here's the problem. Microsoft, in all its wisdom, allows PCs on XP to be setup with users having administrator rights. In some businesses (possibly many?) networks are just slapped together with a "nest" of these administrators...

Well there ya go. RE-did the service pack 7 (well, I though that I had done it before) and voila! No crashes. For completeness, the error in the log was "Faulting application maserplus.exe, version 2009.5.0.13, faulting module kernel32.dll, version 5.1.2600.5512, fault address 0x00012aeb."...

Damn CR9! I can run the same report n times but on n+1 my program just crashes with that lovely windows message telling me that I may send the error to Microsoft. There is absolutely NO rhyme nor reason to it: same report, same sql stored procedure, same parameters, same every damn thing...

My instance of mssql 2005 has no Administrator rights, ergo I have effectively "forced" a logon with user name and password. Well ... thats great for MY instance but there is nothing stopping an unscrupulous user from stopping my instance, copying the database, attaching it to an Administrator...

Permissions ... hmmmmm select * from openquery([fred], 'Update drugnote set dntnote="test1" where dntcode="ANPE1"') works fine but returns (not suprisingly) error 7357 which aborts the procedure. changing this to update fred...drugnote set dntnote='test1' where dntcode='ANPE1' returns Msg...

the current VPFOLEDB.DLL does not allow updates nor deletes with a linked server. So ... I want to create my own. Is this possible?? and if so ... how??? Thanks

I have a mssql 2005 database with a linked server to a FoxPro9 database. As you can see below I just want to dynamically construct an openquery. Please help or direct me. Thanx Fetch Next from OOS into @OrderDate, @Company, @DrugCode, @Message, @QtySupplied, @QtyOrdered While @@Fetch_Status...

awesome Thanks

I am implementing a MSSQL 2005 express instance as the "back end" to my app. This app will be self-installed onto networks where (I just know) all users have been setup as Admin, therefore they can access my database with Windows Authentication: not a good thing. As I cannot change the end-users...

Golom It's a pleasure to read your code. Neat, structured, uncluttered ... how it should be for developers who will follow-on from you.

First I assign the correct printer to the printer object then I assign that printer to the report as with ReportToDisplay.SelectPrinter Printer.DriverName, Printer.DeviceName, Printer.Port But it VIEWS in the font of the default printer. What the &%@$? And, of course, the report prints in...

I wish to add "C:\Program Files\Microsoft SQL Server\MSSQL.x\MSSQL\Binn\sqlservr.exe" to the firewall list of exceptions where "x" is the number of the instance. How do I determine the instance number during installation? For reference I am using innosetup.