RE: Backup cannot be performed on this DB
I think your error message got cut off from your post. Would you please repost your error? Thanks.
2003-12-11
1 reads
Storage Management
RE: Stored Proc and Master DB
I don't know how are you using the parameter but this sholud helpyou going Declare @str varchar(200) SET @str = DB_NAME()--Assuming is going to be runned from other databases only --otherwise use dbname as a parameter +'.dbo.sp_helprolemember ' + '''' + 'RoleName' + '''' --print @str exec (@str) I don't know why can't the "plus" […]
2003-11-13
RE: Export to Excel without DTS. Possible?
Thanks for the tip of using Tab delimted, renamed to XLS. It works great! Using xp_sendmail, do any of you know a way to change the default attached message from .txt to .XLS?
2003-08-28
RE: Index for column with a lot of Null
BTW, tikus, this table does have clustered index on it, right? If not, the logical and extent scan frag numbers on SHOWCONTIG should be ignored. Just checking the basics, I guess...
2003-08-27
RE: Continuous replication
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-07-24
RE: Resize data file
Hi again ... Firstly, thank you for the responses. I am running SQL2000 ADV SERV with SP3. There is just one .mdf and one .ldf to this database. The available drive space is in excess 200GB. The drive configuration is RAID 5. Shas3------------------------------------ Expanding your database from 1MB to 50GB take long time. Who many […]
2003-07-24
RE: Fetch next not working
While this shouldn't loop forever, I imagine you actually want something different. First, you are not using the value read by the cursor. The statement of INSERT INTO... will read from the entire table of junkgood for each row. It probably seems like the program is looping forever because of the duplicates. Which brings me […]
2003-07-11
RE: Date calculations
GREAT! it works final code: Avg(DATEDIFF(day,[dteprinted],[dtereceived])) AS AvgLead
2003-06-05
1 reads
2003-05-30
2 reads
RE: maximum number of prefixes
Create sp in serverA to select data from remote_server and call the sp from server B, C and D. create procedure sp2000_helpdb as select * from [remote_server].master.dbo.sysdatabase in server A exec [server_A].master..sp2000_helpdb in server B, C, and D Edited by - Allen_Cui on 05/28/2003 1:20:05 PM
2003-05-28
1 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers