If your application was written correctly in the first place then you would only have to make the change ONCE in yolur application!One correct way of doing this properly the first time is to create a module with connection string in it and make it Public, then you could just call that module anywhere in […]
2004-03-22
THanks for your reply but No I just want to exclude them from my SP's output ...I am running it as a sceduled job directly into a file ... Any takers ?
2004-03-17
here is what I mean: declare @a int, @b intset @a=0set @b = select count(*) from tablenamewhile @a <= @bupdate table where key >= @a and key < @a+ 1000set @a = @a+1000 --commit every 1000 rowloop We could commite the row every row or every so many thousand row depending on how you want to set it […]
2004-03-16
Yes. You need to upgrade to SQL Server 2000. SQL Server 7 did not allow computed columns in keys.
2004-03-16
We need to have a script that will open files in a directory and all sub-directories and execute the sql in each file. I have a start on such a script but I was wondering if anyone has a solution that I am unaware of, or if a script exists on this site that I […]
2004-03-15
7 reads
I've done this before...Like This:1. Shut down the SQL Services MSSQLSERVER and SQL Server Agent on both boxes.2. COPY the database files (.mdf .ndf, .ldf) from old server to new server, placing them in the same directory names on new server. Master and msdb should overwrite on new server, and tempdb doesn't need to be […]
2004-03-11
Here is an easy way to accomplish this. Right-click on each DTS package and schedule each separately into three SQL Server Agent jobs. Then look at the step properties for each of the SQL Server Agent jobs you just created, copying and pasting the DTS command from each into a new SQL Server Agent job […]
2004-03-11
I have accepted this recommendation due to the performance impact, and don't argue that. But I find that this has killed for me the utility of object-ownership in general. Has anyone made good use of object ownership since following this "always owner-qualify object references" guideline? I haven't. Just an extra "dbo." that I have to add everywhere--more typing with no benefit. But back […]
2004-03-10
2004-03-08
There is undocumented stored procedure available to achive you needs, I personally use it often:EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', '', 80)" The proc will reindex everything with fullfactor = 80 in this case.Julia
2004-03-05
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers