Search results for query: *

Justin...that did it! Thanks

I have read a ton about this and still can't get it to work. In the XML doc I want to display the "title" in multiple lines. Any help would be greatly appreciated. Code below. Thanks...Mitch ************************************ XML DOC --------------------------------------- <?xml...

Hi: In Photoshop I can create some text, select it (marching ants) go to Modify / Expand select the size and I now have an expanded selection. Is there any way to do this in Illustrator? Scaling is not the same. Thanks, Mitch

George, The system tables I am talking about would be the ones that are created automatically when you create a new DB. I would think I would not want a user who is restricted to one single USER table to be able to mess around with the system tables? Thanks, Mitch

George, SWEET!!! Worked perfectly for all of the USER tables. But it did not update the SYSTEM tables, seems like I should deny access to those also? Anyway to do that? MichaelF81...thank you for your help also! Thanks! Mitch

OK, this works: DENY Select, Insert, Update, Delete ON TABLENAME TO USERNAME GO I ran it in Query Analyzer and it works table by table, is it possible to apply the above to an entire Database in one shot? Thanks, Mitch

THANKS!!! Do you know if something like this would work: DENY Select, Insert, Update, Delete ON authors TO Bob GO Mitch

Hi, On SQL 2000 using SQL Authentication I created a new user and had to give them access to only 1 table. The "problem" is that there are a lot of tables, views and stored procedures that I had to one-by-one select explicit deny (RED X) on Select/Insert/Update/Delete and Exec on the SP's. As...

Denny, Sorry for the delayed response...thanks for the info. I decided that I did not want to mess with the security settings seeing that we are trying lock stuff down and be more secure so I just setup the DTS to FTP IN the file, import it then delete the file from the local and remote...

Denny, Thanks for the tips. Do you know by chance which Windows Account SQL uses when running a DTS package? Thanks! Mitch

Thanks. What's I don't understand is that it works if I manually execute it from Enterprise Manager (DTS\local packages) But fails if scheduled. I should also mention that I am doing all of this via remote desktop, not my local computer. Mitch

Hi, I created a DTS package with a connection similar to this example using a bogus IP: FILE: \\10.15.1.201\c$\websites\localuser\sitename\foldername\filename.csv The package is on our SQL Server Box and the file is on a different server...our web server. If I run the DTS package manually it...

Hi, I am working in After Effects 6.0 Pro. I am trying to bring in a simple text animation that I am creating in a simple 3D program (Xara 3D5)...the size of the animation is 600x600. In After Affects I am working on a 800 x 600 composition and when I import the text animation, it's "canvas"...

Hi, I created a pretty straightforward CD-ROM presentation using Director 7 (yes it's old but it works and I cannot justify the upgrade because I do not use it too much). The CD-ROM uses wav files that are linked not embedded to via the timeline and play automatically when the viewer enters a...

Hi, The following code works perfectly but now I want to do a little tweak at a different part of the DTS package. What I want to do is to delete files that are blank so they are not FTP'd to the remote server (a zero byte TXT file). I can see in my head what I need to do to the code, but I...

DNG, I have to say that I am very surprised that you could enter so much code in a default value. When I saw your code it dawned on me to use the code that I was using elsewhere that was doing the HHMMSS. This worked fine: REPLACE(CONVERT(VARCHAR(10), GetDate(), 108), ':', SPACE(0)) A...

AA, The code needs to go in the Default Value of the field in Enterprise Manager, I believe the code you provided would be for a select statement? Thanks, Mitch

DNG, So close, it returned: 18:59:43 Any ideas how to get remove the ":"? Thanks for responding so quick! Mitch

I need some advice, I thought I was done with this project when I suddenly realized that because I was capturing the User Time (format = HHMMSS) on the form page they were submiting the time would be hours earlier or later than the server time. I know I can use getdate() as a default value for...

Hi, What I am trying to do in (ASP MSSQL) is to query records by the time submitted as compared to the current time and the current time minus 5 minutes. The time for the records is captured in this format: HHMMSS into a field called TIMESUBMIT So if the current time is 7:00:00AM the query...