RE: Modify DTS at run time
You find samples on http://www.sqldts.com or read this article http://www.databasejournal.com/features/mssql/article.php/2225481
2003-06-27
1 reads
Analysis Services (SSAS)
RE: QOD june 27 select * from
Again a case of careful reading. asp-page, web app, ado... But to be honest, I was more guessing than knowing. Anyway two points are two points Cheers, Frank
2003-06-27
RE: How to make a SP stop automaticaly after s.time?
Sorry was talking crock before, why break a habit of a lifetime . The following works though. ------------------------------- declare @startdate datetime, @enddate datetime, @count int set @startdate = getdate() set @enddate = dateadd(mi, n, @startdate) --where n is the minutes you want to time out after set @count = 1 while @count > 0 begin […]
2003-06-27
RE: Defragment table data?
I believe they don't do the data defrayment, but if you re-organize the data you really don't have to do the data defrayment.
2003-06-26
RE: Looking for online resources
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-06-26
RE: Local system account vs Domain user
Thanks Marcus, Can I change from local account to domain wihtout reinstalling SQL? Thanks
2003-06-26
RE: Moving all log files to a new disk
Take a look here at this KB article it talks about moving databases. Moving logs are done the same way except you list the original position of the data files.
2003-06-26
1 reads
RE: unique values
Is this what you want? CREATE TABLE [dbo].[Test] ( [ColA] [int] NOT NULL , [ColB] [varchar] (5) NOT NULL , [ColC] [money] NOT NULL) GO ALTER TABLE [dbo].[Test] WITH NOCHECK ADD CONSTRAINT [PK_Test] PRIMARY KEY CLUSTERED ([ColA],[ColB]) GO
2003-06-25
RE: SQL Restore
Were any changes made to the Operating System? I've restored successfully after upgrading Service Packs to SQL Server so that shouldn't be your problem. But upgrading your operating system could be. -SQLBill
2003-06-24
RE: SERVER NAME LENGTH
All our servers are called IDIS2KDS01 etc. Never had a problem Cheers, Crispin
2003-06-24
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