Remove last record from the text file!
What's the easiest way to remove last row from the text file using SQL Server Integration Services? Thanks. ...
sql-server
Importing Active Directory Users and Groups into SQL Server (possibly via c#)
I need to import all ad groups in a few OUs into a table in SQL Server 2008. Once I have those I need to import all the members of those groups to a different table. I can use c# to do the work and pass the data to SQL server or do it directly in SQL server. Suggestions on the best way to approach this? ...
Limit Database List to Ones With Permission SQL Server
By default if you connect to a remote SQL Server via an account that has access to say 1 of the 10 databases. You will still see in the Object Explorer all other databases, obviously due to permissions you cannot actually query them, but you can see their names. I have heard that there is a method that disable this behavior, but I've b...
SQL Reporting Services DataConnection Update
Is it possible to change the connection string of a published sql reporting services report? I can see the binary field called DataSource in the ReportServer database, but since it's stored as binary I don't think it's easily updatable. Do I need to republish the report with the correct data source? I'm hoping not since I do not want to...
SQL procedure running time widely divergent
I have an application that runs a huge stored procedure on SQL Server 2000. Usually it takes about 1 minute to complete, but occasionally it will take MUCH longer. Just now I ran it three times in a row in my test system. It took 1:12, 1:23, and 55:25. What would cause that behavior? There are other things going on in the database, so I...
Quality Indicators TFS 2008 report and multiple build types
In a project we have two build types, one for continuous integration and one that runs our test suite. When the Quality Indicators report is run, it displays data from all builds regardless of build type. The report suggests that one can only run it on a specific build type but the query that populates the builds field only seems to wo...
SQL Server 2005 auto growth by size
I have been looking at the new database server we are setting up for a client and note the database files are set to grow by 1 meg everytime the file is full and the initial size is 100 MB. I have been considering this breifly and it doesn't sound right. I've checked a few sites on DB considerations and they didn't properly explain the...
Can a BCP version 8.0 format file have a column name that is a SQL keyword?
I have a format file where I want one of the columns to be "group". I'm auto-generating the format file and a client wants to upload a file with "group" as one of the columns. I could restrict it so they can't use SQL keywords, but then I need a function to determine if a column name is a SQL keyword, so I'd like to support the user be...
Is there a class or method in Java that will check if a string is a SQL Server keyword?
I want something that can check if a string is "SELECT", "INSERT", etc. I'm just curious if this exists. ...
Limits on number of Rows in a SQL Server Table
Are there any hard limits on the number of rows in a table in a sql server table? I am under the impression the only limit is based around physical storage. At what point does performance significantly degrade, if at all, on tables with and without an index. Are there any common practicies for very large tables? To give a little domain...
What optimistic locking scheme would you recommend for SQL Server?
I am building an enterprise application with .Net 1.1 and SQL Server 2000. I use the read committed isolation level . However changes in non-functional requirements have made it necessary to take measures against non-repeatable reads and phantoms. I see two options: Introduce row-versioning to check if a row has been modified since it...
Custom Date/Time formatting in SQL Server
I am trying to write a stored procedure which selects columns from a table and adds 2 extra columns to the ResultSet. These 2 extra columns are the result of conversions on a field in the table which is a Datetime field. The Datetime format field has the following format 'YYYY-MM-DD HH:MM:SS.S' The 2 additional fields which should be i...
Sql Server SHRINKDATABASE command
When I shrink a sql server database using the GUI (All Tasks->Shrink Database->Accept all defaults, click OK), it finishes quickly. But if I run this command, it takes a very very long time. DBCC SHRINKDATABASE('my_database') What am I missing? This is in SQL Server 2000. ...
Normalizing search text to full text search and where conditions
What you want is for users to just type in their search criteria just like they would in Google. Some words, maybe some quoted phrases, maybe a few operators, and have it just work. A .Net solution is available here: http://ewbi.blogs.com/develops/2007/05/normalizing_sql.html I am looking for a pure T-SQL version with where support als...
Unit tests framework for databases
I´m looking for a unit tests framework for database development. I´m currently developing for SQL Server 2000, 2005 and 2008. Do you know of any good frameworks with similar functionality as JUnit and NUnit? Perhaps it´s better to ask, what do you use to unit test your stored procedures and user defined functions? ...
MS Access query design hangs on connection to SQL Server
Microsoft Access is a slick way to access data in a MS SQL Server backend database, but I've always had problems accessing (so to speak) large tables of data, especially when trying to toggle between results and design mode in Access. Access gives me a number of nifty things, not the least of which is Crosstabs, but this hung connection...
How do I connect to a MSSQL database using Perl's DBI module in Windows?
How do I connect to a MSSQL database using Perl's DBI module in Windows? ...
Anybody know why SQL Server 2005 throws "'SQLOLEDB' failed with no error message available, result code: E_FAIL(0x80004005). "?
We've got a web system running SQL Server 2005 for the back end, and ASP.Net for the front end (using .net 2.0). Every now and then, the system barfs out the error in the title: 'SQLOLEDB' failed with no error message available, result code: E_FAIL(0x80004005). The web system runs just fine 24/7, and then every now and then will toss ...
Undo changes to SQL Server 2005 database
I've ran some "ALTER" scripts on the database [SQL Server Server 2005], and overwrote some sprocs. Is there any way to undo changes and get my old sprocs back? Is there a way to get the scripts that were executed out of the .LDf file? That way i can re-run my initial "create" script for my sprocs. I don't have a backup file with old sp...
TSQL Extended Procedure 'xp_dirscan'?
What is the equivalent of the extended procedure 'xp_dirscan' in SQL Server 2005? ...