Hi,

In the following article http://technet.microsoft.com/en-us/library/ms189334.aspx When you use /3G the kernel will use 1G from the RAM and other applications 3G from the RAM.

Regards,

Ahmed

Hi David,

Check the following links

http://www.simple-talk.com/sql/sql-server-2005/beginning-sql-server-2005-xml-programming/[/url].

Reading an XML file from SQL Server

http://www.builderau.com.au/architect/webservices/soa/Reading-an-XML-file-from-SQL-Server/0,339024590,339174685,00.htm

How to import XML into SQL Server with the XML Bulk Load component

[url=How to import XML into SQL Server...

Hi,

From Bol

http://msdn2.microsoft.com/en-us/library/ms174269.aspx

When a database is in the RESTORING state, most ALTER DATABASE statements will fail. The exception is setting database mirroring options. A database may be in the RESTORING state...

Hi Anujahnavi,

I am sorry for the delay, I made a lot of tests (also I made a lot of search over the Internet).

It seems the problems are :

- The last...

Hi,

I will do the following:

1- I will set a testing environment.

2- Use the profiler/MDVs (sys.dm_exec_query_stats, sys.dm_exec_sql_text) to check queries that take long time to execute.

3- Check the execustion plans to...

Hi stef,

Use a trial of SQL Compare from redGate (a good tool).

Regards,

Ahmed

Hi,

Check the followings links :

http://www.sql-server-performance.com/tips/awe_memory_p1.aspx

http://blogs.msdn.com/slavao/archive/2006/08/03/687573.aspx

http://technet.microsoft.com/en-us/library/ms187499.aspx

http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx

http://support.microsoft.com/kb/274750

http://technet.microsoft.com/en-us/library/ms190730.aspx

http://support.microsoft.com/default.aspx?scid=kb;en-us;274750

http://msdn2.microsoft.com/en-us/library/ms190673.aspx

Regards,

Ahmed

Hi Ashwen,

check the following links

http://www.dbforums.com/showthread.php?t=393743

http://support.microsoft.com/?kbid=299889

Regards,

ahmed

Hi,

--1 Enable Full text indexing on the Database

Exec sp_fulltext_database

--2 Create the catalog (unless you already have)

EXEC sp_fulltext_catalog

--3 Add a full text index to a table...

Hi Rama,

The syntax for wzzip is the following

1- wzzip [options] zipfile [@listfile] [files...]

For example wzzip -a c:\test.zip c:\*.txt

2- You use

set @job = 'wzzip -ys4700000...

Thanks Ramesh for your help.

If you use a BCP inside the trigger :

- If the BCP use another table, it will work

- If the BCP use the same table (for...

Hi,

Check the Following link http://www.databasejournal.com/features/mssql/article.php/1459571

Regards,

Ahmed

hi vyas,

we tried it, the output is an xml file, we have not the appropriate output.

Tks

Hi anujahnavi,

I made a mistake in the query

EXEC master.dbo.xp_cmdshell 'bcp "select * from tablefortrigger order by track FOR XML Auto" queryout "d:\anu.xml" -S. -Usa -Puniverse -c, no_output

but still not...

Hi satishchandra,

From bol

http://msdn2.microsoft.com/en-us/library/ms186552.aspx

SQL Server 2005 database diagrams and SQL Server 2000 database diagrams are created and rendered differently.

Because of these differences, SQL Server Management Studio cannot work with SQL...