Viewing 15 posts - 5,401 through 5,415 (of 7,429 total)
Use FileSystem object to do this. It has a deletefile method. For more info and a basic example see MSND Library online at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/jsmthdeletefile.asp
"Don't roll your eyes at me. I...
June 17, 2002 at 5:08 pm
Check out http://support.microsoft.com/default.aspx?scid=kb;EN-US;q274463 for info on this, which is permissions like you state. One question though, did you have to change the accounts while SQL is running, if so then...
June 17, 2002 at 5:05 pm
Usually I use *both* since we use a lot of web applications and remote applications. However on two of ours, due to the fact the only accounts that can access...
June 17, 2002 at 4:59 pm
55% CPU and 390MB of RAM should be a none issue. Have you tried running the query the report is submitting in QA to see if it returns when the...
June 17, 2002 at 4:55 pm
I haven't seen this. However as a thought check in EM the DB properties and see your Recovery Model. Maybe in BULK LOGGED model which will log all bulk type...
June 17, 2002 at 4:51 pm
Looks that way. Sorry about my confusion hard to understand any of that documentation (not friendly at all). Without being able to play with myself with this type server I...
June 17, 2002 at 11:13 am
Check out http://www.sql-server-performance.com/service_packs.asp for a fairly good list.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 17, 2002 at 10:30 am
Have you tried connecting as and Admin account and then DCRM account in QA or EM to see what happens? If no difference run DBCC CHECKDB (see BOL) to check...
June 17, 2002 at 10:28 am
What version of SQL and ServicePack level on it? I tested on SQL 2000 SP 2. Can you post A and B code, it may be something to do with...
June 17, 2002 at 10:25 am
quote:
Now the intersting thing is that you could specify the identity as a bigint according to BOL, however I've got a very...
June 17, 2002 at 9:14 am
The key to query plans are what steps did the Query Manager decide to take to get the results. For instance is the query uses a table scan instead of...
June 17, 2002 at 8:57 am
I tried this and the only thing I had to do was set the user account up in public on the database, nothing more. Works fine for me, and when...
June 17, 2002 at 8:46 am
You will get an error like this.
Server: Msg 8115, Level 16, State 1, Line 1
Arithmetic overflow error converting IDENTITY to data type tinyint.
Arithmetic overflow occurred.
Except where you see tinyint you...
June 17, 2002 at 6:48 am
Which options are you selecting as my NT accounts are being scripted just fine. This is the output on my test database.
if not exists (select * from dbo.sysusers where name...
June 17, 2002 at 6:40 am
In addition, you state you are somewhat new to SQL. Make sure your backups are to another drive not on the same as the databases themselves. You may have installed...
June 17, 2002 at 6:27 am
Viewing 15 posts - 5,401 through 5,415 (of 7,429 total)