Search results for query: *

SQL Server 2000 (8.0.2039) I need to grant execute permissions on a stored procedure that updates a table to a user that does not have update permissions on the table the sproc updates. I can't get this working. I use grant execute on dbo.sprocname to username and get UPDATE permission...

I need a way of passing strings larger than varchar or nvarchar (8,000) into a stored procedure. There seems to be a problem with using the text datatype; like you can't. Can anyone offer a creative solution for this? Thanks so much!

We have a vendor that decided using SQL keywords was ok for column names. I have a column named "fulltext" that I must manipulate. BOL states that you can do this but that you then must address them as quoted identifiers. I can't get anything to read this column when used in a function like...

I am using the CF MX 7 Report Writer for the first time. Does anyone know how to supress the blank lines that occur when a text area is not fully populated? For exaple, I have item and description. The description is not always the same length. That leaves balank lines between each item. Thank!

I have spent about 10 hours on this issue so far trying everything that I can think of to work around this so any help would be greatly appreciated. I just feel like there should be simple solution here, I just may not be seeing the forest through the trees. I am trying to find all employees...

I need to generate a key for a feed from a couple mainframe systems to a SQL 2000 box. This will be a new high end server. The feeds will be dumping data into SQL at up to 300 TPS. Is there anyone already doing something like this? Also, I'm told that it is more efficient and less likely...

Does anyone know where the view/edit records is in 2005? I'm looking for the same functionality that is in Enterprise Manager where you could view/edit a group of records. Of course I know how to do it via query analyzer :) Thanks! Craig

I can not get Cyrstal Reports in Visual Studio .NET to see the output of a stored procedure containing dynamic sql. It runs fine in query analyzer but when adding a new Crystal Report in Visual Studion the wizard I select the stored procedure under data, click next and no fields are visible...

What is the best way to convert several RAW (Canon D10) photos to JPG format? I know that occassionaly I will want to give specific photos more attention, but in general it will be a mass conversion. Thanks for any help or leads in the right direction :) Craig

Is Photoshop CS licensed to one PC or one user? I just purchased my upgrade and while I HATE the new activation processes I do understandy why it is place. I certainly don't mind paying for a great product that I use frequently. I would love to be able to load my new version at home and at...

How would you add text to the job history output? That is the area when you go into the job history and click 'show step detail'. I'd like to log some information here when some of my jobs complete. By default it shows this: Executed as user: TPL00\sqlservices. Can you hear me now [SQLSTATE...

How would you create a unique index or constraint that allows NULLs? I need to insure that the value entered into one colum is unique, if it is entered. Bad design I know, I just have to fix an issue with a db that someone else put together. Thanks! Craig