I am toying with the idea of enabling CLR on my SQL server, using EXEC sp_configure 'clr enabled', 1
However, I am sharing my database server with several other developers and their projects. I've heard vaguely that their might be security issues with enabling this.
Does anyone know what these issues might be? Is CLR safe to use on SQL Server?
There is not a clear category on the site where to post this, so giving it a shot here.
Has anyone used VS 2008? I current user Turtoise for some projects, and Source Gear Valut for others.
The company where I work is thinking about moving to VSS because of the MSDN subscription.
My experience with VSS prior to VSS 2005 was that it conied the name "Visual Source Unsafe" and I know first hand that it trashed my work more that once and I stopped using it. Source Gear Valut on the other hand is rock solid.
So is VSS 2008 Really "safe" was VSS 2005 "safe" ?
I have an query recently i upgrade to Visual Studio 2010 professional version, I have an visual source safe 2005 in my pc how do i configure Visual studio 2010 with VSS 2005.
View 1 RepliesI used SQL SERVER 2008 R2 express as my web development database and I set its compatibility level to 2005. Unfortunately this database cannot be be attached to SQL server 2005. Are there any other options?
View 3 Repliesi had the sql 2008 enterprise and i want to go back to sql server 2005 because in 2008 i created new database but when i did some changes in the table , it gave me an eror that i cant save thins and i need to creat new one if some one know what i'm talking aboutif not i need the sql server installation tutorial i tried by myself but probebly i did it wrong and now i cant connect well to the sql
View 2 RepliesI am integrating SqlCacheDependency to use in my LinqToSQL datacontext.I am using an extension class for Linq querys found here - http://code.msdn.microsoft.com/linqtosqlcacheI have wired up the code and when I open the page I get this exception - "The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported. Please enable the Service Broker for this database if you wish to use notifications."its coming from this event in the global.asax
protected void Application_Start()
{
RegisterRoutes(RouteTable.Routes);
//In Application Start Event
System.Data.SqlClient.SqlDependency.Start(new dataContextDataContext().Connection.ConnectionString);
}
my question is...how do i enable Service Broker in my SQL server 2008 database? I have tried to run this query.. ALTER DATABASE tablename SET ENABLE_BROKER but it never ends and runs for ever, I have to manually stop it.once I have this set in SQL server 2008, will it filter down to my DataContext, or do I need to configure something there too ?
I can't figure this out. I have a simple ASP.NET application that I am hosting on my computer which all local computers can hit. The next thing I want to do is setup the website for public access. No matter what I can't seem to get it to work.
- I have allowed incoming connections to port 80 through the firewall.
- I have setup my router to port forward all HTTP requests (80) to my locally assigned IP (192.168.1.XXX).
- I have setup my server to use anonymous authentication, which is set to "Application pool identity".
- I have even shut off my firewall to try and see if it would work.
Can't figure this out. Read a bunch of information, and in my head this should work, but it seems like I am missing something simple. I realize this thread's subject matter applies to IIS7 more-so than ASP.NET, however since I am relatively new to ASP I figured maybe I missed an ASP setting or something.
where to find/download visual source safe plug in or visual source safe client for visual studio 2005 IDE?
I do not want to install visual source safe 2005 server.
I'm writing a Project Managemet system. I want to access VSS to determine what is checked in/checked out.
View 1 RepliesI want to use a source control in VS2010, I know my best bet is TFS, but at the moment TFS(can't afford ). As i understand TFS is the new VSS_2005(can afford)Can VSS 2005 be use as a source control for VS 2010 solutions/projects?
View 2 RepliesI have a class which implements IHttpHandler that is designed to handle image resize requests. It handles Urls like so [URL] Currently the handler looks for myimg.jpg on disk, cuts a 100x100 thumbnail (if it isn't already present) and redirects the client to the thumbnail like so Response.RedirectPermanent("/some/virtualPath/to/thumbnail.jpg");
This has been working great, but I would like to avoid forcing the client to issue a second HTTP request. Is it safe to do the following? Server.Transfer("/some/virtualPath/to/thumbnail.jpg") All the MSDN documentation talks about using Server.Transfer() to redirect to an aspx page, so I'm not sure if this is the right thing to do or not.
I have to programmatically import a table from a database "A" in Sql Server 2000 to a database "B" in another server 2005.
View 1 RepliesI want to convert sql server 2000 database into sql server 2005 database. I am using sql server 2005 express.
I am trying by taking backup/Restore method, but it not work.
I need help making selections on my installation of SQL Server 2005 Developer Edition onto my Laptop (the only computer in my house). I need to develop a couple of different databases and use them from my Visual Studio applications. Then I will upload the SQL databases and the Web Applications to GoDaddy for deployment to general public.My question is that installation is asking me questions I honestly don't know how to answer because I am using a different SQL this time around after reformatting my hard drive"
1. Do I use Default or Named Instance?2. Do I use the Built-In System account or a Domain User account?3. If answer 2 is Domain User then I am in trouble because I don't think I have a Domain, and I don't know what one is. Where would I find the user name, the password, and the domain?
Migrating SSIS package from SQL Server 2005 to SQL Server 2008
View 1 RepliesPrevious developers have developed a .SSISDeploymentManifest file (SQL Server 2005) to install SSIS packages which prompts a Package Installation wizard. I tried to install it on SQL Sever 2008 (it works on SQL Server 2005), but it failed with the error: "Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported".
How do I install 2005 SSIS packages on SQL Server 2008? I have all the .dtsx files, not sure how to install them?
How can convert DTS package from SQL Server 2000 to SQL Server 2005
View 2 RepliesDoes anyone know, what is difference between SQL Server 2000, 2005 and 2008?
View 3 RepliesCould anyone tell me the features comparision between sql server 2000, 2005 and 2008 in the table format like below. sql server 2000 features | Extra features added/supported in 2005 | Extra features supported in 2008
View 2 Replies assist me rectifying the error in following sql stored procedure?
Sql Query:- [Code]....
I have created the above Stored Procedure for inserting datas into any table but while I execute the above proceedure its throwing some error.
I am using Sql Server 2005,My table structure is below.
Create Table ComentTable(id int,coments varchar(4000))
insert into ComentTable values(1,'sanjay I don%27t Know Tamil Language')
insert into ComentTable values(1,'sanjay I don%27t Know Kanar Language')
how to write storeprocedure update coments column replace %27 to '
I have one asp.net 2.0 application with MS Sql 2005 database.. As i deploy this database with client Machine.. now what i need is i need to take a backup of MS Sql 2004 database.. so is that any free tool is available which take daily backup...
View 16 RepliesI have created my database in SQL Server 2005 Enterprise Edition and now planning to tranfer this databse to another server, But this other server is SQL Server Standard Edition, So if i try to attach my database which is created in Enterprise Edition will get sucesully connected to Standard Version ? or i will get any error message or i am doing something wrong ? This situation is fine or Version should be kept same ?
View 2 RepliesIn machine XPSP2, I tried to install SQL SErver 2005 express edition (downloaded from the microsoft site) - after mode selction form (Windows/SQL server authentication) - system restarted, automatically.Again restarted, Again restarted,Again restarted,Again restarted,a 1000 times or more.finally I unplugged the system from the UPS
View 2 RepliesI want to generate 30,000 cards and each card must be duplicate check with database. In my card, there are 2 things. Serial No and CardID. If any card already exists then I generate another card id but with the same serial no.
So how faster way I can generate 30,000 card with duplicate check? Which one I have made application, it takes about 25 minutes to insert.