Search results for query: *

Does anyone have a solution for password protecting or write protecting a PDF file with .net code or a free third party tool writen i managed .net code?

Hi! Reporting Services do not support write protecting or password protecting rendered PDF files. How can I do it after the render? We render the document in our desktop application so we have full control over it. We have also developed a merge method to merge several pdf documents to a...

No, GOTO does not work. The label SkipToEnd: should not be visible for the GOTO statement because it's in another batch (because it's on the other side of a GO command). RETURN only works in a procedure, not in a script.

Yes but to be able to specify a severity level higher then 18 the user has to be a member of the sysadmin role. If the user for example is the database owner, an error of level 16 will be raised: Server: Msg 2754, Level 16, State 1, Line 30 Error severity levels greater than 18 can only be...

No, it does not stop by using raiserror. The current batch stops but the next batch (after the next GO) will still execute.

Hi, how do I abort an SQL-script when it contains the GO command? I want to be able to send the customer a script that creates tables, views and storred procedures etc. and be able to abort the script. At the start of the script I check some stuff and if it's not right I dont want to run the...

I'm using it from the client (Visual Basic 6). The error occurs when I try to instanciate an object (New).

I try to use sql dmo (sqldmo.dll) on a computer. It works fine when an administrator use my application but it does not work for any other user. First I got error number 70 when I tried to create an instance of sqldmo. When I changed the access rights for the file sqldmo.dll the errormessage...

Hi, What scope does XACT_ABORT affect when I set it in a stored procedure? The entire server? The connection? SET XACT_ABORT ON SET XACT_ABORT OFF

If you don't have a source and just want to insert some test data you can use WHILE to create a loop. Example: DECLARE @nNrOfRows int, @nRow int SET @nNrOfRows = 100 SET @nRow = 0 WHILE(@nNrOfRows > @nRow) BEGIN INSERT INTO ... SET @nRow = @nRow + 1 END

...[aaaaaTableName_PK] PRIMARY KEY NONCLUSTERED ( [ColumnName] ) ON [PRIMARY] GO To create a view: CREATE VIEW dbo.ViewName AS SELECT * FROM TableName GO To create a SP: CREATE PROCEDURE dbo.usp_SpName ( @nInputParameter int ) AS SELECT * FROM...

Hi, Can I with vba-code check what version of Access the user is using?

Hi, if you write protect an .adp or .ade file you get a warning message when you open it: "The database xxx will be opened read-only...". Can I remove that warning message? Is't wery confusing! The user realy think that the DATABASE is read only when it's only the klient that is...

Hi, I want to set ownership (to "Administrators") with code. I know you can use cacls.exe to set permissions but how do you change ownership? //Martin

It's no problem with the functionality of ImgEdit but you don't have any control over the installation if you want to distribute your application. You can't create a setup that installs everything you need. The user himself must install the Imaging for Windows software package from the Windows...

Hi, Does anybody know anything about components for editing images? I am looking for an alternative for the ImgEdit component that’s included in Windows. Just mention a name or point me in the right direction.

...need to convert the value to an int. You also need to convert the dates to get rid of the time (like in the previous example). Example: SELECT * FROM tblCase WHERE convert(datetime,convert(char(12),dateadd(dd,convert(int,tblCase.Allotted),CaseDate))) =...

Hi, I have a rather large Access project connected to an SQL-Server. The larger the project gets (more code) the longer time it takes for it to start up. Even if I shift-start it. No code is running, and no data is fetched from the database. It's just the time to load the file. Do anybody have...

Hi, I have a rather large Access project connected to an SQL-Server. The larger the project gets (more code) the longer time it takes for it to start up. Even if I shift-start it. No code is running, and no data is fetched from the database. It's just the time to load the file. Do anybody have...

You can't use variables in OPENQUERY() either. I'm using 21 allmost identical linked Access databases. Right now I have the declaration of the cursor and the "FOR"-SQL code written 21 times. The code is identical except for the linked server name. I should want to use a variable for...