SQL Server Management Studio
You will need to uninstall the Management Studio, then install a retail copy to get the management studio back on the machine. You can also download the Express edition of SQL Server, but the management studio for Express is missing features.
View Answer
| June 10, 2009 3:21 AM
SQL Server administration, SQL Server Management Studio
You will need to uninstall the Management Studio, then install a retail copy to get the management studio back on the machine. You can also download the Express edition of SQL Server, but the management studio for Express is missing features.
View Answer
| June 10, 2009 3:21 AM
SQL Server administration, SQL Server Management Studio
Visa and SQL compatibility issues
Taking a stab that SQL server Data Engine = MSDE, aka SQL 2000 MSDE, you will need to upgrade to at least SQL Server Express 2005 (plus a few patches) for Vista compatibility. Try here. <a href=”http://www.microsoft.com/downloads/details.aspx?familyid=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en”></a>
View Answer
| June 9, 2009 7:29 PM
SQL Server, SQL Server Compatibility, SQL Server Data Engine, Vista, Vista compatibility
Taking a stab that SQL server Data Engine = MSDE, aka SQL 2000 MSDE, you will need to upgrade to at least SQL Server Express 2005 (plus a few patches) for Vista compatibility. Try here. <a href=”http://www.microsoft.com/downloads/details.aspx?familyid=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en”></a>
View Answer
| June 9, 2009 7:29 PM
SQL Server, SQL Server Compatibility, SQL Server Data Engine, Vista, Vista compatibility
SQL Server 2005 -I want duration from the condition below- without cursor would be preferred
While it is possible to do this without a cursor, the resulting query will be (IMHO) highly inefficient as the database grows. Here is a query that will return your answer: select t.contractid, t.status, sum(datediff(d, t.fromdate, isnull(t.todate,getdate()))) days from ( select c1.contractid, c1.status, c1.moddate fromdate, c2.moddate todate from DurationCalc c1 outer join DurationCalc c2 on [...]
View Answer
| June 9, 2009 5:59 PM
SQL Server 2005, SQL Server Condition
While it is possible to do this without a cursor, the resulting query will be (IMHO) highly inefficient as the database grows. Here is a query that will return your answer: select t.contractid, t.status, sum(datediff(d, t.fromdate, isnull(t.todate,getdate()))) days from ( select c1.contractid, c1.status, c1.moddate fromdate, c2.moddate todate from DurationCalc c1 outer join DurationCalc c2 on [...]
View Answer
| June 9, 2009 5:59 PM
SQL Server 2005, SQL Server Condition
SQL 2005 Password
The sa password will be that of the SQL 2005 instance. Passwords are stored in the master database which you can not move from a SQL 2000 instance to a SQL 2005 instance.
View Answer
| June 6, 2009 8:32 AM
SQL 2000, SQL 2000 to 2005 Migration, SQL 2005, SQL Database, SQL migration, SQL passwords
The sa password will be that of the SQL 2005 instance. Passwords are stored in the master database which you can not move from a SQL 2000 instance to a SQL 2005 instance.
View Answer
| June 6, 2009 8:32 AM
SQL 2000, SQL 2000 to 2005 Migration, SQL 2005, SQL Database, SQL migration, SQL passwords
AD Domain Admin permissions to SQL
By default everyone who is a member of the servers Administrators group is a member of the sysadmin role. This can be changed by removing the BUILTINAdministrators group from SQL Server’s sysadmin role. Before you do this be sure to grant the DBAs admin rights. Once the domain admins don’t have sysadmin rights to the [...]
View Answer
| June 6, 2009 8:30 AM
Active Directory, Active Directory Administration, Active Directory Permissions, SQL Permissions
By default everyone who is a member of the servers Administrators group is a member of the sysadmin role. This can be changed by removing the BUILTINAdministrators group from SQL Server’s sysadmin role. Before you do this be sure to grant the DBAs admin rights. Once the domain admins don’t have sysadmin rights to the [...]
View Answer
| June 6, 2009 8:30 AM
Active Directory, Active Directory Administration, Active Directory Permissions, SQL Permissions
VB.NET – Can’t insert data into database.
From <a href=”http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldataadapter.aspx”>MSDN</a>: <i>”The SqlDataAdapter, <b>serves as a bridge between a DataSet and SQL Server for retrieving and saving data</b>. The SqlDataAdapter provides this bridge by mapping Fill, which changes the data in the DataSet to match the data in the data source, and Update, which <b>changes the data in the data source to match [...]
View Answer
| June 5, 2009 2:04 PM
SQL Server 2005, VB.NET, Visual Basic .NET
From <a href=”http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldataadapter.aspx”>MSDN</a>: <i>”The SqlDataAdapter, <b>serves as a bridge between a DataSet and SQL Server for retrieving and saving data</b>. The SqlDataAdapter provides this bridge by mapping Fill, which changes the data in the DataSet to match the data in the data source, and Update, which <b>changes the data in the data source to match [...]
View Answer
| June 5, 2009 2:04 PM
SQL Server 2005, VB.NET, Visual Basic .NET
connetion failed ,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL
Can you telnet from the remote machine to the SQL Server’s TCP port (usually port 1433)? If not then there is a firewall on either one of the machines, or on the network between you which is blocking the connection.
View Answer
| June 4, 2009 7:43 PM
SQL Server 2005, SQL Server Remote Connections
Can you telnet from the remote machine to the SQL Server’s TCP port (usually port 1433)? If not then there is a firewall on either one of the machines, or on the network between you which is blocking the connection.
View Answer
| June 4, 2009 7:43 PM
SQL Server 2005, SQL Server Remote Connections
SQL 2005 Password
Why don’t you just try to change the password? If the old one works, you will successfully change to the new password. If the old one doesn’t work, then you will have confirmed that you don’t have the valid password to the account (bad news!). You should be able to alter the password with: ALTER [...]
View Answer
| June 3, 2009 9:27 PM
SQL Server 2005, SQL Server Passwords
Why don’t you just try to change the password? If the old one works, you will successfully change to the new password. If the old one doesn’t work, then you will have confirmed that you don’t have the valid password to the account (bad news!). You should be able to alter the password with: ALTER [...]
View Answer
| June 3, 2009 9:27 PM
SQL Server 2005, SQL Server Passwords
query for join
Assuming that your Rules table always has TWO UnitId values, separated by a comma, then I would suggest using a function to return the two strings, e.g.: create function TwoStrings ( @inID int ) return varchar(255) begin declare @outString varchar(255) declare @temp varchar(128) declare @unitID1 varchar(32) declare @unitID2 varchar(32) set @temp = select UnitID from [...]
View Answer
| June 3, 2009 12:09 AM
JOIN statement, SQL Server Query, SQL Server tables
Assuming that your Rules table always has TWO UnitId values, separated by a comma, then I would suggest using a function to return the two strings, e.g.: create function TwoStrings ( @inID int ) return varchar(255) begin declare @outString varchar(255) declare @temp varchar(128) declare @unitID1 varchar(32) declare @unitID2 varchar(32) set @temp = select UnitID from [...]
View Answer
| June 3, 2009 12:09 AM
JOIN statement, SQL Server Query, SQL Server tables
Optimize the query in sql server
Have you had a look at the execution plan for the query ? A full table scan on a 30 million rows table would be expensive. ——————–
View Answer
| June 2, 2009 3:29 PM
SQL Server 2000, SQL Server Query, SQL Server query optimization
Have you had a look at the execution plan for the query ? A full table scan on a 30 million rows table would be expensive. ——————–
View Answer
| June 2, 2009 3:29 PM
SQL Server 2000, SQL Server Query, SQL Server query optimization
Bulk Insert with collation change
You can’t import the system tables. These hold the schemas of the objects that you are already scripting out.
View Answer
| May 30, 2009 3:24 AM
Bulk Inserts, Database collation, Database migration, SQL Server 2000, System tables
You can’t import the system tables. These hold the schemas of the objects that you are already scripting out.
View Answer
| May 30, 2009 3:24 AM
Bulk Inserts, Database collation, Database migration, SQL Server 2000, System tables
Database and Log file location
Here is a <a href=”http://www.phwinfo.com/forum/ms-sqlserver-setup/201362-sql-2005-database-default-location-during-setup.html”>good discussion </a>which may help you. When you get to the list of services to install, click the Advanced button. Expand the SQL Server engine menu item, and select database files. Change the folder here. This will set the data file and log files to the same thing. You’ll need to [...]
View Answer
| May 30, 2009 3:19 AM
SQL 2005, SQL Database, SQL Installation, SQL Log Files
Here is a <a href=”http://www.phwinfo.com/forum/ms-sqlserver-setup/201362-sql-2005-database-default-location-during-setup.html”>good discussion </a>which may help you. When you get to the list of services to install, click the Advanced button. Expand the SQL Server engine menu item, and select database files. Change the folder here. This will set the data file and log files to the same thing. You’ll need to [...]
View Answer
| May 30, 2009 3:19 AM
SQL 2005, SQL Database, SQL Installation, SQL Log Files
Find exact point where SQL Server 2000 job fails
You could add some logging to the procedure, for example, inserting into a log table, or using the <a href=”http://msdn.microsoft.com/en-us/library/aa260695(SQL.80).aspx”>xp_logevent procedure</a>. If you are using explicit transactions, you might want to log to a table variable, and insert to an actual database table from it after rolling back your transaction. ———————————— Odds are you are [...]
View Answer
| May 30, 2009 3:14 AM
SQL Server 2000, SQL Server development, SQL Server error messages
You could add some logging to the procedure, for example, inserting into a log table, or using the <a href=”http://msdn.microsoft.com/en-us/library/aa260695(SQL.80).aspx”>xp_logevent procedure</a>. If you are using explicit transactions, you might want to log to a table variable, and insert to an actual database table from it after rolling back your transaction. ———————————— Odds are you are [...]
View Answer
| May 30, 2009 3:14 AM
SQL Server 2000, SQL Server development, SQL Server error messages
Delete Rows from SQL DATABASE BEFORE Import To THE SQL DATABASE USING SSIS
You’ll need to run a T/SQL task and put a DELETE or TRUNCATE statement in there to remove the data from the table.
View Answer
| May 30, 2009 3:00 AM
SQL Database, SSIS, SSIS 2008, SSIS Package 2008
You’ll need to run a T/SQL task and put a DELETE or TRUNCATE statement in there to remove the data from the table.
View Answer
| May 30, 2009 3:00 AM
SQL Database, SSIS, SSIS 2008, SSIS Package 2008
Alter SQL table
<pre> USE yourdb GO ALTER TABLE dbo.yourtable ADD code1 VARCHAR(20) NULL ALTER TABLE dbo.yourtable ADD code2 VARCHAR(20) NULL GO DECLARE @number int DECLARE @code varchar(20) DECLARE @code1 varchar(20) DECLARE @code2 varchar(20) SELECT * INTO #yertbl FROM dbo.yourtable DECLARE tblcur CURSOR FOR SELECT number, code FROM #yertbl ORDER BY number OPEN tblcur FETCH NEXT FROM tblcur [...]
View Answer
| May 29, 2009 3:33 PM
SQL, SQL tables
<pre> USE yourdb GO ALTER TABLE dbo.yourtable ADD code1 VARCHAR(20) NULL ALTER TABLE dbo.yourtable ADD code2 VARCHAR(20) NULL GO DECLARE @number int DECLARE @code varchar(20) DECLARE @code1 varchar(20) DECLARE @code2 varchar(20) SELECT * INTO #yertbl FROM dbo.yourtable DECLARE tblcur CURSOR FOR SELECT number, code FROM #yertbl ORDER BY number OPEN tblcur FETCH NEXT FROM tblcur [...]
View Answer
| May 29, 2009 3:33 PM
SQL, SQL tables
Microsoft ISA Server 2000 – Firewall service deliberately stopped – Want to allow ping.
It may be just a simple matter of opening any external firewall before the ISA box to permit ICMP to reach this ISA server. However, ICMP is not really a good thing to leave open really. It can be used as an attack vector. I would recommend enabling a firewall and permitting only ICMP from [...]
View Answer
| May 27, 2009 6:57 PM
Firewalls, ICMP, Internet Control Message Protocol, ISA Server, ISA Server 2000, Ping, Web security, Windows Server 2003
It may be just a simple matter of opening any external firewall before the ISA box to permit ICMP to reach this ISA server. However, ICMP is not really a good thing to leave open really. It can be used as an attack vector. I would recommend enabling a firewall and permitting only ICMP from [...]
View Answer
| May 27, 2009 6:57 PM
Firewalls, ICMP, Internet Control Message Protocol, ISA Server, ISA Server 2000, Ping, Web security, Windows Server 2003
SQL Server query
Your table structures are needed in a question like this… The query would be something like this: <pre>SELECT DATEPART(mm,purchase_date),COUNT(*) FROM your_table WHERE purchase_date between ’2008-01-01′ and ’2008-12-31′ GROUP BY DATEPART(mm,purchase_date);</pre>
View Answer
| May 27, 2009 3:06 PM
SQL queries, SQL Server administration
Your table structures are needed in a question like this… The query would be something like this: <pre>SELECT DATEPART(mm,purchase_date),COUNT(*) FROM your_table WHERE purchase_date between ’2008-01-01′ and ’2008-12-31′ GROUP BY DATEPART(mm,purchase_date);</pre>
View Answer
| May 27, 2009 3:06 PM
SQL queries, SQL Server administration
Database Issues – Trying to prove that something has to be done
Questions: The 88 Million records – are they current? – Needed for periodic processing? – Does a purge process exist? 150 Logical Files — is it the PF with 88 million records??? – when considering the effect on updates/writes to the system discount any with Maintenance *DELAY or *ReBUILD – are updates/writes to this file [...]
View Answer
| May 26, 2009 7:23 PM
AS/400, Database, Database issues, Indexes, iSeries, iSeries Navigator, Logical File, PF, SQL, SQL tables
Questions: The 88 Million records – are they current? – Needed for periodic processing? – Does a purge process exist? 150 Logical Files — is it the PF with 88 million records??? – when considering the effect on updates/writes to the system discount any with Maintenance *DELAY or *ReBUILD – are updates/writes to this file [...]
View Answer
| May 26, 2009 7:23 PM
AS/400, Database, Database issues, Indexes, iSeries, iSeries Navigator, Logical File, PF, SQL, SQL tables
SQL update a column to remove a certain character
If you are sure that the only non-numeric character that appears in the column is the asterisk, you could use the REPLACE function this way: <pre> UPDATE book SET your_column = REPLACE(your_column,'*','');</pre>
View Answer
| April 19, 2013 2:28 PM
SQL, SQL tables
If you are sure that the only non-numeric character that appears in the column is the asterisk, you could use the REPLACE function this way: <pre> UPDATE book SET your_column = REPLACE(your_column,'*','');</pre>
View Answer
| April 19, 2013 2:28 PM
SQL, SQL tables
DBCC CHECKDB
When you run the normal DBCC CHECKDB it will tell you what objects are having problems that require that data be deleted. After you have run DBCC CHECKDB you should restore the most recent backup that isn’t corrupt and find the exact records which are now missing so that you can replace them from the [...]
View Answer
| May 22, 2009 9:22 PM
DBCC CHECKDB statement, SQL, T-SQL
When you run the normal DBCC CHECKDB it will tell you what objects are having problems that require that data be deleted. After you have run DBCC CHECKDB you should restore the most recent backup that isn’t corrupt and find the exact records which are now missing so that you can replace them from the [...]
View Answer
| May 22, 2009 9:22 PM
DBCC CHECKDB statement, SQL, T-SQL
