Topic profile page for SQL Server 2005.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: SQL Server 2005.
Topic "Sql server 2005" was discussed 13,268 times on 646 sites in last 3 months
Started 22 hours, 6 minutes ago (2009-11-09 12:50:00)
by AgentM
Hi, I need to move a SQL server 2005 database nearly 9 GB to another machine on a different domain. What is the best way to do this ? I tried taking a backup then do a restore on the new machine and it failed with an "Access denied error". thanks for your help.
Started 1 day, 8 hours ago (2009-11-09 02:06:00)
by asuni449
Hi All, I am using sql server 2005. I had one table with so many columns. and i had one times tamp data type column also. Now, i want to insert a record with : INSERT INTO PARTY SELECT * FROM PARTY WHERE P_CODE = 'ABC' i am getting error as : Msg 273, Level 16, State 1, Line 1 Cannot insert an explicit value into a timestamp column. Use INSERT with a column ...
Started 1 day, 22 hours ago (2009-11-08 12:45:00)
by BBellot
Every time I try to use the automatic update for the Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706), it fails. I haven't been able to find a solution online. I'm currently running Windows XP, Service Pack 3
Started 2 days, 13 hours ago (2009-11-07 21:29:00)
by computer156
i have been tryin to dl microsoft SQL server 2005 express edition service pack 3 (KB955706) for the past 2 months and always get the same prob. it always say error code:534- window has encounter an unkown error. i got a feelin tat it is due to the update file bein corrupted as my lenovo laptop T400 crashed once. But i m not sure. any suggestion? pls dun tell me to look at microsoft web help. ...
Started 3 days, 16 hours ago (2009-11-06 18:03:00)
by Tha_Tyrant
I've read a lot of posts saying that either you shouldn't or should upgrade to vs2008 if you're still using sql server 2005 BI. I don't have the ability to make any changes to the server setup, getting sql server 2008 is a matter of waiting on my organization to make the move. Can someone give me the definitive do/don't upgrade visual studio? Thanks, Ken
Started 5 days, 3 hours ago (2009-11-05 07:08:00)
by muraruadrian
I have some problems to export IAS-RADIUS server logs in a SqlServer2005 database Theoretically, it is done in two steps: 1. IAS server configuration: interface configuration specifies the server name(Host name), the database name, user & password and then testing the connection(all must be created in sqlserver before testing connection) 2. Configure SQL2005 server: here is a little more work....
Started 5 days, 18 hours ago (2009-11-04 16:49:00)
by stoneheart
I'm hoping someone can point me to the right direction for this. I want to be able to convert my existing query which returns multiple records into a view that would look sort of like a spreadsheet. My query that returns something like this: 1 Number_of_Bolts 11 2 Number_of_Nails 325 3 Number_of_Pins 1355 The query itself is: select question_id, ...
Started 5 days, 21 hours ago (2009-11-04 13:39:00)
by Bob Hmine
I've got SSDS, SSAS, and SSIS running on Server A. I've got SSRS and MOSS running on Server B. Q1. Do I only run/apply SQL Server SP3 on Server A? Q2. Do I only run/apply the SharePoint-SSRS Add-in on Server B? Q3. Is the order of the installation SP3 and then SharePoint-SSRS Add-in? Thanks....
Hello, we have a SQL Server 2005 installation that was running it's service as a local user on it's own machine. Recently the machine got upgraded as an Active Directory domain controller and now the SQL Server Management Studio won't allow me to logon since it was using Windows Authentication mode only. How can I change it's service ...
Started 6 days, 14 hours ago (2009-11-03 20:53:00)
by SVYATOSLAV ISAYEV
have been trying to get the AMI setup with IIS and SQL Server 2005 Express with Advanced Services (I need Reporting Services and SSIS). And so far very unsuccessful. Is there an AMI that already have all this. If not, can anyone give me a good direction as to how to do this? Thanks in advance.
Started 1 week, 1 day ago (2009-11-01 17:32:00)
by Harp Cyclone
I am migrating a database I have been developing in SQL Server 2005 from a XP SP3 machine to a Win 7 machine. I am wondering if I should be installing the 64 bit version in Win 7 or stay with the 32 bit version for continuity?
Started 1 week ago (2009-11-02 14:53:00)
by Fritz Theiss
hi, due to some specific performance tests we would like to fullfil in our company, we would like to disable the caching mechanism of sql server 2005 (if possible). could someone please let me know how to do so? Signature thanks in advance / danke im voraus, fritz -- Fritz Theiss
Started 6 days, 17 hours ago (2009-11-03 17:09:00)
by george greiner
Hello I need to run a query in SQL Server 2005 that counts to a Chr(13) which is a line feed and pulls all data to the left of it. I understand there is no InStr function in SQL Server 2005 and that I need to use CHARINDEX. I tried the following: LEFT (defendant_info, CHARINDEX(CHAR(13),0) -1) AS def But it appears that either it does not recognize the CHAR(13) or my parameters after that are...
