You can disable check constraints and foreign keys by executing for each of them the

ALTER TABLE mytable NOCHECK CONSTRAINT name_of_constraint

for the indexes you can disable them (see alter index),...

Sys.columns has a default_object_id. This is the id of the default, which you can access via the sys.default_constraints system view. The sys.default_constraints shows the definition of the default in the...

Lester Policarpio (10/1/2007)

---

The 2 databases(version 7) that will be restored in different server is 70 and those databases in the server with ms sql version 2000 is 80 any problem...

Babu Mannaravalappil (10/1/2007)

---

Thanks all for the replies.

I already wrote an application using SMO to iterate through all the objects in a given database and populate a tree. The business...

Do check your database's compatibility level after the restore, and set it if you are not happy with it.

see sp_dbcmptlevel

Regards,

Andras

syscolumns contains a row for every column/paramter in your database.

select * from syscolumns

In syscolumns you get the identifier of...

FerasGer83 (9/28/2007)

---

i want to ask a question about the principle of backing up data.

what's the benefit of backing up log files?

if we have the data, what we could need log...

Babu Mannaravalappil (9/27/2007)

---

Hi all,

I am using .net 2/C# to write an application that will populate a tree with all the objects available in any given database on a particular Sql...

Babu Mannaravalappil (9/30/2007)

---

Hi All,

Is there a way to extract the script for an existing database object (table for example) programatically using T-SQL system objects or procedures? I know I...

David Putman (9/28/2007)

---

I need to run some searches with a full text index but at present I am developing on a laptop with SQL 2000 and I have no access...

andri (9/30/2007)

---

Hi all,

Anyone can help me with my issue,

I migrate my database from MS-SQL 7.0 to MS-SQL 2005,

then for this table, every time i did an update to the...

You can calculate this yourself. The basic formula is along the lines of:

6 (status bits, .. header like stuff)...

x-portal (9/28/2007)

---

Did upgrade...I unistalled 2000 and installed 2005. I think i did it wrong. Cause i lost all the user names and linked servers. But I dunnot what i did...

Unfortunately your exception message got truncated. java.lang.Short is a class, and the full exception message should contain a bit more information 🙂

Have you tried debugging the above application? If...

mkhines (9/28/2007)

---

I have a web application that works perfectly fine on SQL 2000. It’s written in JSP and on a Tomcat/Apache web server.

I set up on a laptop...