Try Visio 2002 Professional

Vera (10/22/2008)

---

SQL server 2000, stored procedure with EXEC sp_executesql @sql.

@sql is declared as nvarchar(4000) which seems to be the maximum size.

However, sometimes my parameter including the statement exceeds this size.

How...

xavendano (10/21/2008)

---

How to register a DLL in Windows CE 5.0 ....

I understand that you must use the application regsvrce ...

Q1: Where do I find this file as in...

Arul Manoj (10/21/2008)

---

I have table to store user login details. Now i want to get the time difference for each login for all users. The table is as below

User Id...

timscronin (10/21/2008)

---

I have an imported record set where the name is just one field in a table. I need to split it out to last,first,middle.

Here is what data looks...

jwellington (10/21/2008)

---

Hi,

I need to create a trigger but am only new to the language. Could anyone suggest the programming for the following:

I have 2 records (by SiteID) per link (by...

sayfrend (10/21/2008)

---

Very easy and best way to do this which involves no Scripts and no hassles.

Create a DTS/SSIS package

create a source connection to sql1 database

create a destination connection to...

luissantos (10/21/2008)

---

Hello Comunity

I have the following script :

SELECT (case when lp.u_pagpagar=0 and lp.u_pagchpd=0 then '222' else case when lp.u_pagpagar=1 and lp.u_pagchpd=0 and lp.u_eodc=1 then '268' else

case when lp.u_pagpagar=1 and...

twdavis (10/20/2008)

---

I need to compare tables on two sql databases for differences with one customer

the first problem is

I am not sure how to select two diffrent datebase with the...

Kiran Kumar MP (10/21/2008)

---

I'm working on SQL server 2000 and I'm getting following error sometimes:

"Transaction (Process ID 69) was deadlocked on lock resources with another process and has been chosen...

Running a job continuously leads to performance issues.

But if still you want you can use...

scptxfr.exe is missing from the SQL-server 2005 versions. you can find this...

nithin.gujjar (10/21/2008)

---

The two queries are returning two different no of rows.Outer join is not supposed to duplicate the rows in the first table right?How do I correct this.

select * from...

sanya.ibrahim (10/19/2008)

---

Hi,

I have a Db in MSSQL2005. Some of the machines running the front end are stand alone and so have their own sql db. I want to...

You can...