Lynn Pettis (10/5/2007)

---

Just me, but the only "small" data type I wouldn't use is smalldatetime. Why introduce a "Y2K" type issue by limiting your dates to January 1, 1900,...

The answer is very simple depending on what the job is doing the Agent needs admin permissions or proxy admin permissions because deleting backup files is very serious business Microsoft...

Oracle secret weapon is VP Jim Melton who is ANSI SQL editor who edited the XML section in ANSI SQL 2006. That got me very worried because for political...

You could try backup and restore that is backup the database in the old server and restore in the new one, you just put the .bak in the backup subfolder...

Your RDL(report definition language) and solution files should be in your development folder I am assuming you created one. So go to new add new item under reports in...

sindhu_sing (9/24/2007)

---

Hello I am new to sql server 2005....i have downloaded the 180 days trial version.

I don't have the sql server agent in my version...so how can i create jobs...

You are doing it wrong you don't create the proxy account for a user rather you create the proxy for SQL Server Agent to execute the package with a job,...

Actually there is a version of Express with Reporting services but it require a separate component called the ToolKit. The Fulltext feature was also added reluctantly after developers added it by...

I found this link in your link which most people may not understand so Microsoft support create the link I posted as a short version of it.

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

 

A datawarehouse developer have no use of SQL Server Express Advanced services included because you only have access to a limited Reporting services.  The developer edition is the Enterprise edition...

In the same link for the VWD you can download the VB Express it is free and use it with the Tool kit to develop SQL Server Reports, all you...

Try the first link for correct SQL Server DateTime setup and the second link for all the SQL Server DateTime covert codes.  Hope this helps.

http://www.karaszi.com/SQLServer/info_datetime.asp

http://sqljunkies.com/Article/6676BEAE-1967-402D-9578-9A1C7FD826E5.scuk

This problem is solved with Advanced Save as in VS2005 that is you save your code as Cryillic because Cryillic is not easy to localize.  There is a work around...

That depends so try the link below and print out code page 1252 the TXT version and CP850 the TXT version to see the difference, and the short answer it is related to...

I don't know how granular it is in 2000 but in 2005 they are not the same because CP1 is code page 1252 the generic western Europe code page while...