Sql Server 2005
Sql Server 2005
The microsoft sql server product team has increased the Database Size limit for SQL Server 2008 R2 Express from 4 GB to 10 GB. So if you have any SQL Server Express database that is close to the 4 GB Limit Its time to upgrade to R2 Express. Enjoy for free
I was writing a store proc for a report and i needed some data from another server so i added a linked server to connect to this new db server. when i do a select like below its all fine select a,b,c from Server.DatabaseName.dbo.table But when i use the table in a join i get the error "Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation." I did check the collation set on the 2 databases and it was actually the same and...
I just came across this article and i taught its a good resource for BI Developers and other Analysts. Hope it helps
When you create a database i'm sure you can grant users/roles access to stored procedures tables etc.. But if you inherit the sql database then you will need to find a solution Unfortunately, with all of the security changes in SQL Server 2005, no default role is available to execute all stored procedures in a given database.Quite sure the same applies to SQL SERVER 2000. But there is a solution looking at the script below: Just pass in the loginname below to the stored proc CREATE PROCEDURE spGrantExectoAllStoredProcs...
The Network admin guys did some windows patch update on the WSS v3 - OS - Windows 2003 server Until after logging on to the site tried doing some searching and Oops no search results returned So i taught sure the services has stopped or i have to restart the service but after checking the services on the OS and the Sharepoint Central Admin everything thing looks ok. Well its time to look for a fix So what next and where to start . First was this Microsoft Support site: but didn't solve the problem....
I was in the process of using SqlSiteMapProvider class today by jeff which is a new feature of ASP.NET 2.0 and i have always wanted to try this out My main goal is to have a database driven site navigation interface with a securitytrimming feature which i know is possible But after running the sql script to insert some sample tables to the DB and setting upt the project in VS 2005. Ran F5 to run a sample page and bingo error: The SQL Server Service Broker for the current database is not enabled After...
I came across this full list of standard report at: Reports full list I think this is very handy for Developers and will increase prodcutivity. A good organization should make use of this :)
I have been using Sql Server Reporting Services for a whie now and i have been out looking for a detailed comparison between Crystal Reports and Sql Server Reporting Serrvices. I finally found this detailed article at devx.com So i decied to share with other developers out there. Enjoy
To all Sql Server devlopers .DBA's etc.. I came across this article describing about some useful and new datatypes in SQL SERVER 2008 Like date, time, datetime, datetime2 and datetimeoffset datatypes You can get to it here .Although the article is based on SQL Server 2008 - Nov CTP but lets hope it will be in the finished product. Hope it will make your jobs easier...
I was just surfing around the net looking for resources on SSIS and i came across this fantastic tips here Happy coding
Full Sql Server 2005 Archive