error 29528 installing SQL 2005 SP2/3 on 2003 server DC (!)0498 (11/16/2009 2:13:02 PM) Utfhello,
i ran into the error 29825 while installing SQL 2005 SP2 and 3.
the server is a 2003 x86 but is also a Domain Controller!
i found the link to this article which seems to work for many people.
Importing a text file. 'Strange' behavior.01057 (11/16/2009 12:36:35 PM) benDear Reader,
Importing data with SQL-Server 2005.
Using DTS in SQL-Server 2000 works fine.
Importing the data into an Excel spreadsheat works fine.
But using 2005 we get a number of issues.
So I tried ...
User Account Only by ODBC Not SSMS (SQL 2005)1668 (11/13/2009 2:50:01 PM) Utf
I have a SQL Server 2005 database server that has a SQL user account that I
would like to restrict it from connecting with SSMS only connecting with ODBC.
Is there something I can do with the user accoun...
Q on Maximum server memory4576 (11/15/2009 12:41:01 AM) UtfI just bought a new PC with Windows 7 64-bit and 12 GB of RAM. I'm running
SQL Server 2008 Enterprise Edition on it. Previsouly, I was running XP
32-bit with 4 GB or RAM. The default setting for SQL Serv...
DTS question2523 (11/12/2009 9:21:51 AM) SharonHi all,
I am executing a DTS package from a C# application that runs on the IIS.
The database used, is on different machine.
My question is, will i gain performance by executing the package locally on
Create Table Script with Variable1565 (11/13/2009 2:06:52 PM) JonHello all,
Is it possible to do the following when creating a table? I've tried
but it creates the table called @CompanyPrefix_STAFF not JY_STAFF.
Any help would be great.
migrating to a new box0584 (11/13/2009 7:09:02 PM) Utfjust bought a new file server and wish to migrate the contents of current
server (Dell Poweredge 2800) to this new server (Dell Poweredge 2900).
The current server is running 2 instances of SQL, one is a...
Database Tunning Advisor.1476 (11/12/2009 11:27:02 PM) UtfSo, I got this stored procedure which takes on 6 parameters. It has three
statements declare, insert into table variable from select, and select.
I have two identical db's, except for name, restored from ...
Buffer & Procedure cache4599 (11/12/2009 11:50:56 AM) AbbaHello,
PCProcBuffersUsedPct - Monitors the percentage of procedure buffers in the
procedure cache that are used.
PCProcCacheUsedPct - Monitors the percentage of procedure cache that is
Windows/SQL Authentication...2740 (11/12/2009 10:50:25 PM) JamesFriends,
I always read that "Windows Authentication" security is much more secure
than "SQL Server Authentication" security. (Although I don't quite
understand why, exactly.) I also seem to remember re...
RTM version1561 (11/13/2009 9:57:15 AM) AlbertoDear ALL,
anyone of you know which are differences (if any) between sql server 2000
and sql 2000 RTM (released to manufacturing) version ?
SQL Server 2005 Newbie2588 (11/13/2009 4:46:43 AM) ThomasJust installed SQL server 2005 on my Windows 2003 Server
On my windows XP Pro SP3 workstation I have SQL 2000 running I was trying to
connect via Enterprise Manager to the new SQL 2005 server
Will not con...
visual studio and sql server1561 (11/13/2009 1:33:28 AM) RRIf I have installed visual studio, does that license me for SQL Server ? In
other words, do we have to buy another license for SQL or does SQL come with
Visual Studio and hence could be covered with my VS l...
Auditing Select Queries , so that the full query is logged1725 (11/12/2009 4:57:01 PM) UtfHi,
I currently looking into auditing, we want to see who (and when) has
viewed/updated patient information on our database. (I am using SQL Server
2008 and our application is developed in VS 2008).
Cannot gain access to database1904 (11/12/2009 3:40:19 AM) SafinaazHi,
I have the following installed on my machine:
OS - Vista Ultimate
Visual Studio Pro 2008 with SP1
..NET Framework 3.5 + SP1
SQL Server Developer Edition 2005
SQL Management Studio Express
SQL Client ...
Query Analysis1596 (11/12/2009 2:42:10 AM) RGOur production server version is sql server 2000. For sometime now we have
problems with certain queries which are called from stored procedures. I
decided to capture trace using profiler.
I then took ...
Sporadic performance1649 (11/11/2009 6:21:02 PM) UtfI have a stored procedure for running report on a OLTP system (SQL 2005-No SP
/ Windows 03) and it has a incosistent performance at the end of business day
(5:30PM). Some days the stored procedure ran long...
SSRS 2005 Tables, long cell0961 (11/11/2009 7:01:05 PM) MeghanHello,
I have a table in SSRS 2005 that has a cell with very long content that spans across multiple pages. The data from the cells in the same row as the long cell repeat on each new page. Is there away to...