deepak.a (2/16/2011)

---

hi Gail show and HowardW thanks for your reply.

I am looking something like encrypt and decrypt is there any other way in sql server we can acheive ?

Thanks and...

i fiddled briefly with the trial version of Idera's Virtual Database, which some how magically opens a Full Backup as if it were real, without grabbing disk space, and even...

your email example is another good one; if you need to send an individual email based on each row in a given select, there's no other alternative than a loop...

supposed you have a stored procedure (sp_helptext for example), and you want to call it for every procedure/function or view in the database;

you'd need to either use a cursor,...

ouch that one is not so easy;

The FileSystemObject is still exists in vb.NET/c#, but there are "better" ways to do it...it's knowing which objects are around, and what they do,...

no problem...the format for a backup , or the mdf, is standard between the same versions...2005;

the service that answers requests to access the database may be 32 bit, 64 bit...

i think this is the functional equivalent:

Private Function DoStuff() As Boolean

Dim s As String

...

I Think Mr Celkos post was for a db other than SQL...this is the equivalent:

CREATE TABLE People

(person_id INTEGER NOT NULL PRIMARY KEY,

person_name VARCHAR(35) NOT NULL,

sex_code INTEGER NOT NULL

CHECK(sex_code IN (1,...

remember some tables cannot be truly 100% "backed up" all by itself due to referential constraints....any foreign keys to lookup tables, tables for city/state/etc, would require those related tables to...

AppSup_dba (2/15/2011)

---

I am running a insert query that joins some 6 tables and fetches 3LAKH rows into another table. My TEMPDB size more than 40GB. I am still getting error

Could...

Phil posted exactly what i would have...i would immediately question why your end users are using a tool to view data that is limited to 65536 rows of data;

The advantage...

CELKO (2/14/2011)

---

the scoring starts with 100 points.

1) Did the DDL follow ISO standards and have no dialect? +25

2) Did it have no key?? -25

3) Did you use ISO sex...

ok in that case, here is a solid example;

With PersonInfo(PersonID,Name,Gender)

As

(

SELECT 1, 'Fred','M' UNION ALL

SELECT 42,'Lisa','F' UNION ALL

SELECT 99, 'Pam','F' UNION ALL

SELECT 8,'Peter','M'

),

MyGuys As

(

SELECT Name FROM...

kev this really looks a little bit like a homework question, so I'll give some hints instead of a full answer, unless you confirm it's not homework 🙂

what you ...

ahh i see it.

anything between two single quotes is a literal string...

so this part never gest substituted with your values:

EXEC master.dbo.sp_addlinkedserver @server = '@ServerName,@Port_nbr'

try this instead see how i added...