Because i'm a fan of Hitchhiker's Guide.

42.

Grant Fritchey (2/16/2011)

---

That is a GIANT topic. You really need to develop your own story. If you don't have the knowledge yet to be able to walk someone through what...

I don't think you can do that. Maybe need more explication.The only password you can maybe track is SQL Account. You want verify for change after the first connection ?...

YOu can try with Bulk Insert with loop or you can try with SSIS

42

laddu4700 (2/3/2011)

---

Hi,

I noticed that one of sql server 2005 database has mdf and ndf files (no ldf)

When restored the database someone made mistake, instead of typing .ldf, .ndf is added...

In Active Directory ?

In the case a Account is locked in windows i got this error "Cannot generate SSPI context" Maybe is your case

sa need mixed mode ?

No creater and owner isn't the same thing. You can chose the owner of db when created them.

SKYBVI (2/1/2011)

---

@ pioulot

Agreed, its not weird but if i ran

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

inside the sql server management studio express

IT SHOULDN'T say

9.00.4035.00 SP3 Enterprise...

Ninja's_RGR'us (12/4/2008)

---

JohnG (12/4/2008)

---

Note that even in America, extended ASCII is very common. Just think of all of peoples names that have accents in them. Or the word resumé....

is not Weird. If you use express management studio u can't see Sql Server agent and many other feature like (Sql Server profiler). Use sql Management studio

you need to cast column.

Your ID column is char?

SELECT T.NUMMER,T.NAME FROM SAPPH2.LK_T05_BOM_LATEST_VERSION H

INNER JOIN SAPPH2.PMX_TEILESTAMM T

ON H.TEILESTAMM = T.ID COLLATE SQL_Latin1_General_CP1250_CI_AS

the "=" & Comparaison between 2 table need to...

Same as Steves. I touch type, but not the "right way". During my programming classes i learn it. I can type pretty fast but not with the correct method with...