Viewing 15 posts - 7,096 through 7,110 (of 7,429 total)
Sorry about that, found the big gapping flaw in my code and created this updated version. I took the time and ran against my largest database (10,573,787 rows)
It took me...
February 26, 2002 at 7:35 am
The T stands for Transact so Transact SQL. Thi is kind of like Oracles PLSQL which has extensions to the base SQL methods in Oracle. T-SQL is Microsofts version of...
February 26, 2002 at 7:07 am
Not sure I understand our question. Are you wanting to change a procedure, if so then ALTER PROCEDURE. Other than that can you clarify?
"Don't roll your eyes at me. I...
February 26, 2002 at 6:51 am
Sorry, hit post in error before I said.
What rules of thumb or words of wisdom help you as a programmer?
"Don't roll your eyes at me. I will tape them in...
February 26, 2002 at 5:34 am
The filepath syntax should look like this.
BACKUP DATABASE myDB
TO DISK = 'f:\myDbFull.dat'
Or something similar, just make sure to put path in single quotes.
"Don't roll your eyes at me. I will...
February 26, 2002 at 5:04 am
Why do dynamic at all for this. Unless your example is no fully showing all I need to know you should be able to do
DECLARE @equation VARCHAR(20)
DELCARE @idnr whatever
SET @idnr...
February 26, 2002 at 5:01 am
dbo is the only one by deafult which should look that way. If you see others then Steves statement on sp_change_users_login to fix this mapping is what you need. You...
February 26, 2002 at 4:42 am
Actually no, the server I tested from was (RC, SP1, SP2) on 2000 and (RC, SP1, SP2, SP3) with SQL 7. The problem actually steams form the column order stored...
February 25, 2002 at 7:58 pm
I try to conform you syntax a little to make it run faster, but it should accomplish everything you want or lead you down the right path as I don't...
February 25, 2002 at 7:47 pm
The only user I know of that would have none as the login name is guest account. Where exactly are you finding this?
"Don't roll your eyes at me. I will...
February 25, 2002 at 7:27 pm
I worked previously with a telco and was suprised by how much the networks went down without anyones knowledge but the techs. A lot tracking goes on to keep in...
February 25, 2002 at 11:27 am
Or in EM click the first items row selector (the grey box to the side) and then hold down shift or ctrl to select others the same way and finally...
February 25, 2002 at 11:24 am
Or post your code and let us see if there is another option, also what is input would be helpfull.
"Don't roll your eyes at me. I will tape them in...
February 25, 2002 at 11:19 am
There are ways you could generate scripts without them doing it, but those ways entail a lot of watching or potentially missing changes if multiple people make changes on the...
February 25, 2002 at 11:02 am
Not to step on Robert here, but just a little detail, even though his soultion will work you are required a cursor and a temp table both of which cause...
February 25, 2002 at 10:51 am
Viewing 15 posts - 7,096 through 7,110 (of 7,429 total)