Viewing 15 posts - 24,091 through 24,105 (of 26,490 total)
Directly from Microsoft:
MULTIPLEXING: USE OF MIDDLEWARE, TRANSACTION SERVERS, AND MULTITIERED ARCHITECTURES
Sometimes organizations develop network scenarios that use various forms of hardware and/or software that reduce the number of devices or...
October 22, 2008 at 2:36 pm
Unfortunately, no. You need a license for each user that accesses the database through the web site. In this case, you really need the per processor license for...
October 22, 2008 at 1:36 pm
Even the routine selects should be filtered on the server to reduce the amount of data crossing the network.
I understand about time/political under currents. That was part of the...
October 22, 2008 at 12:06 pm
How is a variable going to retain the last value from the previous run? You have to establish a process that ensures you get the next proper file name.
I...
October 22, 2008 at 12:03 pm
Off hand, not really. I'd use the connection manager to name the file with a base name, then use a FileSystem task to complete the actual rename of the...
October 22, 2008 at 10:38 am
In your Flat File connection manager for the output file just be sure that the Column names in the first data row is unchecked.
😎
October 22, 2008 at 10:20 am
Sorry, it wont as written. You will have to modify the code as I wrote it for SQL Server 2005. You will have turn the CTE into a...
October 22, 2008 at 10:09 am
Based on the article Jack referenced, here is some sample code for you to start with:
create table #TempTable (
RefOne int,
RefTwo int,
...
October 22, 2008 at 10:05 am
Colin Betteley (10/22/2008)
I have a table as follows.
RefOne RefTwo Item Purpose
100 ...
October 22, 2008 at 9:19 am
Just to be sure I read your original post correctly. Users have a local copy of Access on thier desktop systems and are linking tables in this local Access...
October 22, 2008 at 8:19 am
Definitely like Ken's way of doing it. No loops or calculations required.
😎
October 21, 2008 at 11:28 am
Yes, it does. You can use it to create a Data Model.
😎
October 21, 2008 at 11:18 am
Barkingdog (10/21/2008)
>>>What I really want is an "Almost Commodity SW Specialty Tool" which would put it in the $200-$400 range.
>>>
Agreed.
Barkingdog.
Check out Enterprise Architect. The reason I purchased it...
October 21, 2008 at 10:38 am
I use ERStudio here at work, but at home I have Enterprise Architect from Sparx Systems.
😎
October 21, 2008 at 10:13 am
Viewing 15 posts - 24,091 through 24,105 (of 26,490 total)