Viewing 15 posts - 106 through 120 (of 172 total)
Although I have an opinion on your approach, it's been said many times here that the most imporant thing is to be consistent in naming conventions. If you already...
July 18, 2003 at 10:02 am
Sure enough, the guest account had denydatareader.
Thanks a bundle.
Everett
July 14, 2003 at 7:25 pm
Hello.
Joins would be the correct way to handle this. If you'd like more feedback go ahead and post your query.
Everett
June 18, 2003 at 4:10 pm
Hello.
I unfortunately don't have any experience with the DUMP command beyond BOL which suggests it shouldn't be used (GURUS: IS THIS TRUE FOR A ONE TIME SHOT?).
I ran the following...
June 17, 2003 at 11:55 am
Hello. From BOL (Books Online which can be found under Programs - Microsoft SQL Server)...
Updates an existing text, ntext, or image field. Use UPDATETEXT to change only a portion...
June 16, 2003 at 10:29 pm
Hello.
One possibility is the MDAC version. Make sure that the Access host computer is running the same MDAC as the SQL server (MDAC 2.6 or 2.7)
Everett
June 16, 2003 at 10:19 pm
Hello.
One possibility is to use a stored procedure for the more sensitive roles. A stored procedure can have more rights than the User executing it, and the stored procedure...
June 16, 2003 at 10:15 pm
Sorry. It should be: exec(@CreateDatabase)
Here's hoping
Everett
June 16, 2003 at 7:02 pm
Urk
Can you print out the @CreateDatabase and post it? I took your line, modified it
************************************
CREATE DATABASE test1 ON (Name = test1_db, FILENAME = 'd:\Program Files\Microsoft SQL Server\MSSQL\Data\test1')
*************************************
and had...
June 16, 2003 at 5:52 pm
Hello.
The quick answer is replace
'size = ' + @DataSize + ')' +
'size = ' + @LogSize + ')' +
with
'size = ' + CONVERT(char(2),@DataSize)+ ')' +
'size = ' + CONVERT(char(2),@LogSize)...
June 16, 2003 at 4:32 pm
Hello.
By default a Transform Data Task is set to 'Use Fast Load' which causes it to do a bulk insert. If you click off this option...
June 16, 2003 at 1:45 pm
Hello.
Use CONVERT(char(2),@DataSize) and CONVERT(char(2),@LogSize).
If you print out the string @CreateDatabase you'll see that it's being treated as an integer.
Everett
June 16, 2003 at 12:47 pm
Hello.
How about using trigger(s) to write the deletes to archive table(s).
Everett
June 16, 2003 at 12:03 pm
Viewing 15 posts - 106 through 120 (of 172 total)