Viewing 15 posts - 286 through 300 (of 321 total)
( object oriented C# .net no stored procedures. Database viewed as a Persistence Layer -- select/update/insert/delete statements are basically adhoc generated by objects )
Having read only summary articles regarding...
February 19, 2008 at 7:14 am
Syed Anis (2/13/2008)
connectionString="Database= ;Server=.\SQLHES;Integrated Security=SSPI;"
providerName="System.Data.SqlClient
We never have any issue when we were using default instance with the same connection string...
February 15, 2008 at 11:08 am
It is DDL!
I'll see your exclamation point and raise you 2.:w00t:
'S NOT!!!
February 15, 2008 at 10:43 am
I've never heard of DCL or TCL, but I know what GRANT isn't (regardless of what Microsoft says:cool:, so I took a guess at what DCL stood for and ended...
February 15, 2008 at 10:31 am
Sugesh Kumar R. MCDBA
Theory is when you know something, but it doesn't work.
Practice is when something works, but you don't know why.
Programmers combine theory and practice: Nothing works and they...
February 14, 2008 at 12:41 pm
Derek Dongray (2/13/2008)
I think most people would agree that in alomost all systems that use them, 'Purchase Orders' are Transaction data rather than Master data, ...Derek.
Derek,
I wasn't saying that a...
February 13, 2008 at 10:35 am
Actually, Purchase Orders don't even come up to the level of a Transaction. They are more like requests for Transaction(s). While they may be referenced as part of a Transaction,...
February 12, 2008 at 7:03 am
Wow! No time to read all of the comments right now, but I'll add my 2 cents.
Steve Jones said:
...and above all, were easy for a DBA to remember and work...
February 11, 2008 at 9:29 am
mtassin (2/1/2008)
Works great when you have one to open... some of us have made job transitions to SQL 2k5 only shops... :/
Do you mean that you don't have access...
February 4, 2008 at 9:38 am
When I started this site with my partners, we tried to build something open, honest, and community oriented. In other words, a site that we would be proud to be...
February 1, 2008 at 2:33 pm
Maybe for a programmer SSIS is a big improvement over DTS, but for a normal user who just wants to dump the data from a table, it's overly complicated.
I am...
February 1, 2008 at 1:43 pm
I'll still stick to right clicking on the table in QA's Explorer window, and selecting script object to [Clipboard] [New Window]. Works with Mgmt Studio too, but the results are...
January 31, 2008 at 9:41 am
This is going to be interesting. I'm anxious to see the details on the UI.
Tom Garth
January 31, 2008 at 7:51 am
Ah...then that splains..
Correct answers: 94% (803)
Incorrect answers: 6% (52)
Total attempts: 855
--------------------------------------------------------------------------------
No - In SSIS connections can not be dynamically updated. 6%
--------------------------------------------------------------------------------
No -...
January 30, 2008 at 7:46 am
That is truly unfortunate. It seems as though that department's goals are too narrowly focused. That's usually a top down issue, and you probably don't have much control over it.
I...
January 25, 2008 at 3:24 pm
Viewing 15 posts - 286 through 300 (of 321 total)