<br />Excellent detective work![<img src='/community/emoticons/emotion-5.gif' alt=';)' />]
quote:Originally posted by hjyoungii I have a file created as tab delimited that I need to copy to another non SQL server. Any suggestions on how...
[<img src='/community/emoticons/emotion-1.gif' alt=':)' />][<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />Finally got it...
Didn't work. [<img src='/community/emoticons/emotion-6.gif' alt=':(' />]<br />I gave up formatting. [<img src='/community/emoticons/emotion-5.gif'...
quote:Originally posted by Adriaan About the formatting: do the indentations in Windows Notepad, then copy-and-paste into the forum. Adriaan, Let...
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
Silly me [<img src='/community/emoticons/emotion-6.gif' alt=':(' />!]<br /><br />Finally, I figured out what the issue was. I have SQL Server 2000...
Either way, it's giving the same error. I am getting a new backup copy and see what happens with that?
Haywood, Thanks for your time. Didn't solve the problem even after I updated the SP version to 4 as per this article....
quote:Originally posted by Haywood Run RESTORE HEADERONLY FROM DISK = ''C:Documents and SettingsMy DocumentsMyDatabaseMyDatabase_20060912.BAK' and...
quote:Originally posted by Haywood RESTORE HEADERONLY can only handle up to 64 devices in a single command. Sounds like you have more than 64...
Trying to restore a backup copy of database but I am getting this error when I selected backup location from file. Any idea what this means?...
quote:Originally posted by smartrider I am querying users from Active Directory but my results only give me 10000 rows. How can I get all the rows?...
Thanks all for your suggestion. Like I mentioned in the first question, I rarely used(I should say created) UDF in most of my stored procedures and...
quote:Originally posted by dineshasanka Basically a procedure cannot be referenced in our select as we can used in function Hence this is a clear...
Hi All, I have written several stored procedures but rarely used function calls within these stored procedures. Even if I used, they were already...
LOL, I don't know where does this 'if you want to be a dba' thing come from. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]
quote:Originally posted by Roji. P. Thomas This can be easily tested. But I think it makes sense to 1. DROP Non-Clustered indexes 2. Truncate table...
Twan, Thanks for the response.
Separate names with a comma.