Creating clustered index on exiting table
Your only solution is to add more disk space to the database server.

View Answer   |  April 7, 2012  3:20 AM
SQL Server 2005, SQL Server Indexes

update the tables in to two server using a single ssis package
Your SSIS package should have both server/database combinations as 2 different connections Make sure the profile used to execute the package has update/insert permissions to both server/database/table

View Answer   |  April 5, 2012  4:57 PM
SQL Server 2005, SSIS Package 2005

Merging the MDF and NDF files of SQL Server databases
If the NDF is a second file group then you will need to move the table into the PRIMARY file group. This can be done in one of two ways. 1. Create a new table with the same schema, but a different name. Copy all the data from the old table to the new table. [...]

View Answer   |  March 28, 2012  6:50 AM
MDF, Merging MDF and NDF, NDF, SQL Server databases

Insert values into database from form VB.NET
I did somecoding here have a look and tell me what you think: <pre> Public Class PDL_Transaction_Fines_Form Dim bm As BindingManagerBase Dim mdate As String Dim ddelay As String Dim fine As Integer Dim holder As String Private Sub PDL_Transaction_Fines_Form_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load SqlDAtransFines.Fill(DataSetFinesTrans1, “album”) bm = BindingContext(DataSetFinesTrans1, “album”) [...]

View Answer   |  March 24, 2012  9:58 AM
SQL Database, VB.NET

Matching key question – resubmitted
That is because of the collation in use. One solution, could be to use the <a href=”http://msdn.microsoft.com/en-us/library/ms184391.aspx”>COLLATE clause</a>. Here is a blog post with some examples: <a href=”http://blog.sqlauthority.com/2007/04/30/case-sensitive-sql-query-search/”>SQL SERVER – Collate – Case Sensitive SQL Query Search</a>

View Answer   |  March 15, 2012  11:40 PM
SQL Server tables, SQLServer

External Table / SQL Loader
If you are still having problems with the SQL loader, perhaps its time to switch to a commercial SQL loader. They should have less problems. Maybe it would be more compatible with your client. Kathy – <a href=”http://www.cartridgeshop.co.uk”>compatible cartridges</a>

View Answer   |  March 14, 2012  1:28 AM
PL/SQL, SQL Loader, SQL Server

Temporary Internet Files ( long file names – can’t delete )
In Windows if you try to delete a excessively long filename- you get a message that the file cannot be stored in ‘Recycle’. BUT it should delete. Failure to delete can be ‘Norton NProtect’, files that the local user doesn’t own (right click and check advanced on the security tab), or that are in use. [...]

View Answer   |  February 29, 2012  12:17 PM
DataCenter, Desktops, Management, Microsoft Office, Microsoft Windows, OS, Performance management, Security, Servers, SQL Server

Schedule SQL job to run and export to CSV file
We use BCP: set @sql = 'select * from [server].dbname.dbo.tablename' set @bcp = 'bcp "' + @sql + '" queryout serverpathFileName.csv -T -t, -c' exec master..xp_cmdshell @bcp -t, references comma separated values Depending on the version of the BCP utility you may or may not be able to use temp tables.

View Answer   |  May 8, 2013  2:22 PM
CSV, SQL Jobs, SSMS 2008

RUNSQLSTM ALTER TABLE
Message . . . . : Change to field INAME may result in data loss. Cause . . . . . : A change to field INAME in file DWLOAD in library TEST may cause data loss. The reason code is 8. The reason codes and their meanings are as follows: 01 – The field [...]

View Answer   |  February 15, 2012  12:02 PM
AS/400 V5R3M0, SQL tables, SQL/400

Calling stored procedure in a database to query data in another database
If I understand you right, I guess the following is something that you may want to try. Hope it helps. create procedure p1 as select … from db1.tb go create procedure p2 as select … from db2.tb go … create procedure p @db varchar(20) as if @db=’db1′ exec p1; else if @db=’db2′ exec p2; else [...]

View Answer   |  February 14, 2012  8:13 PM
SQL Database, SQL Server 2005

Connecting visual basic with SQL server
you can use ado to connect vb to sql server.

View Answer   |  February 23, 2013  8:45 AM
SQL Server, Visual Basic 2008

Accessing Report Permission Using An Stored procedure in SSRS
The following link will help you out. http://msdn.microsoft.com/en-us/library/ms156034(v=sql.90).aspx

View Answer   |  February 13, 2012  9:20 PM
SQL Server, SSRS

Store and retrieve data in UTF-8 on SQL Server 2005
I had found a way to do it after messing around with it a bit more so I thought I put it here for others to see even though it’s been a few days now. In SQL Management Studio I right-clicked on the database in object explorer and chose Properties->Options->Collation. Then chose a certain language, [...]

View Answer   |  February 9, 2012  8:51 AM
SQL Server 2005, UTF-8

Store and retrieve data from SQL Server 2005 in UTF-8
Hello I am pretty,prettyshina74@yahoo.com I guess you will not surprise to receive my mail? i saw your profile and it sound well.I will like us to exchange good relationship.I am pretty by name,No kid and never marry.from here you can contact me at this email address(prettyshina74@yahoo.com )so that i can send you my pictures and [...]

View Answer   |  February 6, 2012  5:51 PM
SQL Server 2005

How do I resolve this SQL error
The error message is pretty explanatory. You have a table with a primary key, and you are trying to insert a new record that matches the primary key of an existing record in the table. To solve it, review your data and/or your application and do not try to insert duplicate records.

View Answer   |  February 3, 2012  2:48 PM
SQL error messages, SQL Server 2005 error messages

VPN Hollander Powerlink Server issues
You’re out of luck. What is a VPN anyway?

View Answer   |  February 2, 2012  8:37 PM
SQL Database, SQL Server 2005 performance, SQL Server security, VPN connectivity, Windows XP Pro SP3

Backup started running 2x longer
You should look at your disk IO while the backup is running as well as before and after. Maybe someone scheduled a defrag which would sure slow things down (or some other sort of processing). ============= The most possible cause of your hard disk drive to take longer is because there might be a few [...]

View Answer   |  February 1, 2012  8:37 AM
Backup, IBM, IBM Ultrium 3580, OS/400, SSRS

Direct queries to mysql 5.0 on Windows Server 2003 from Oracle 10g on Solaris 8
I haven’t tried this before, but all you should need to do is install MySQL-ODBC and configure a connection between the MySQL and Oracle databases by modifying the odbc.ini files on each server, create an Oracle database link to the MySQL data source, then you should be able to insert, update, delete, and select from [...]

View Answer   |  January 31, 2012  9:20 PM
MySQL 5.0, Oracle 10g, Solaris 8, Windows Server 2003

client server app on local desktop in ncomputing environment
This is a bit complex question. Shortly I can answer this way: Each node needs at least connectivity tools. You are not saying what SQL Server version you use. In general however there is always required minimum. So you should use the setup and load minimum. Next depends on your requirements you need to make [...]

View Answer   |  January 30, 2012  11:21 PM
.NET, Client server software, ncomputing, SQL Server

Windows XP virus Query!
I’ve found this approach helpful in many cases. Boot the machine in Safe Mode (w/NO network support) and log in as administrator. Then go to the folder(s) in question and take ownership, and force that change to propagate. Because the permissions can be tightly locked by some of these pests, you may have to do [...]

View Answer   |  January 30, 2012  8:45 AM
Access, Availability, Bandwidth, Desktops, Hardware, Interoperability, Management, Microsoft Office, Microsoft Windows, Networking, OS, Security, Servers, Software, SQL Server, Tech support