well you can filter it from...

Your application needs to use the techniques for Multiple Active Result Sets (MARS);

just dumping the resutls into a DataReader or DataTable will only get you one of potentially multiple...

the # depends on the SQL server version, and in some cases, the Service Pack version as well.

easiest way is to simply look in SSMS Object Explorer>>Expad Server>>System Databases>>master>>Views>>System Views

Or...

SQL...

SQL server must be installed on the same drive as the %SystemDrive% variable points to; there's no getting around that, but the binaries themselves don't take up nearly as much...

Bruce I've got both 2008 and 20012 installed; although the formatting/font is different for the tooltip on mouseover, i get the same information...

if you create a NEW table, that table...

i see that if any of these four fields are null, the value inserted would be null:

INSERTED.PO_Number + INSERTED.AppUser + INSERTED.SoftwareShortName + INSERTED.HeatTicketNumber,

also , depending on the datatypes, if any...

David the Import Wizard in SSMS is probably the fastest solution.

A full blown SSIS package, bcp /bulk insert with a format file, or the Import Wizard(which is SSIS Lite, really)...

I've got an example of this in my snippets; I've added a last example at the end, which returns just what i thought you asked for: only the words...

Concurring with Gazareth here; if the logins need to be migrated, you need to use sp_help_revlogin , which will maintain the password in an encrypted binary string so it can...

based on the other thread for the same issue the problem is SOME of his data is YYYYMMDD as a decimal, like 20121225, but some of his data is not...

tonyarp05 61903 (11/19/2012)

---

The reason is, Suppose i want to search a string 'Family' in entire database. so that i could get the output which are tables(Fields) are having the value...

in that case, you need...

it will pass your current credentials,which i assume are your windows credentials;

if you hit it as sa, you'd get the typical error for invalid user.

swarup.malli (11/19/2012)

---

Thank you for the reply Lowell,

I was trying to create a view for all the tables.

Could you demostrate how to implement this commoand inside a DDL statement for creating...