I don't know of a way to do this in 6.5, 7 was the first version to allow you to shrink files back down. If you are moving to 2000 you will gain a whole new world of clean up possibilities. What time frame and how are you planning the upgrade? I will look though […]
2002-03-27
VB and VBScript (ASP) with ADO, occasionally Access, MS FoxPro, and some C/C++ (mostly just for processing raw data files prior to BCP.) Playing with VB.NET and C#. Not pure MS, since two of our servers are Oracle (Using VB, Cognos, PL/SQL with those). Played with Borland's C++++ Builder (and enjoyed it) but never any […]
2002-03-26
As far as I know these numbers are just sequence numbers and are generated like UIDs. However I do not have any idea at this point how they are created and if the break done into a representative of anything. Also I have not found anything on this but will gladly post if I do. […]
2002-03-25
You can also use sp_helptext 'viewname' to get it as a recordset. "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
2002-03-22
You can retrieve it from sysobjects or use DMO to get it. Why would you want to alter a view in a web page? Andy
2002-03-22
It's a security issue in that SQL doesn't "lock" accounts, so someone can constantly be connecting to that server and trying passwords. sa is a well known account. You can disable SQL auth and that will help. You can move this port using the Server Network Utility to anything you want. Here we moved it […]
2002-03-21
Wow, are you kidding? The reason I am asking is in our environment we have 8 different db platforms and hundreds of db servers. We are working on a monitoring tool that will go out and query all the different db servers to track transactions and post the results to a web page. It would […]
2002-03-21
1 reads
It's not stored in SQL Server. You can run Profiler to track this. Steve Jones steve@dkranch.net
2002-03-21
1 reads
I think you are doing this backwards. Any changes that you make to your production server should have already been made on your test database. That is the purpose of the test system. Since it's already done, there isn't a good way from SQL Server to do this. RedGate has a product that will help […]
2002-03-21
This is absolutely beautiful. Simple and effective. Thank you very much!!
2002-03-21
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