Here's a few of the new posts today on the forums. To see more, select Discussion Forums in the Community menu on the site:
Tempdb dramatic growth (in SQL Server 2005 only) - Guys,I have the following crazy query written by someone :select platebarcode = a.platebarcode+case when c.sectionid is null then '' else '-'+convert(varchar,c.sectionid) end, a.ABIName, a.threshold,a.XDXana....(more online)
KB932555 - GDR 2050 - Need to uninstall - I have a SQL app that needs to run with only SP1 applied. In error the windows auto update was turned on and a series of updates were applied related to the KB above. When anyone launches the application now, they see a ....(more online)
Try - Catch Message Capture - Currently I am automating backing up a SqlServer 70 compatible database on a SqlServer2005 installation. The backup is working if the input parameters are correct. @argDatabaseName , @argBackupLocation , @argRetentionDaysHow....(more online)
Replication from SQL Server 2000 to SQL Server 2005 - I am in the process of replicating SQL Server 2000 database running on a clustered server to a SQL Server 2005 for reporting purposes. I intend to use transactional replication without the initial snapshot. The Subscriber wil....(more online)
Sharepoint Single Signon configuration - Someone in my group is attempting to setup Sharepoint Single Signon 2007 against a machine running SQL 2005. When they put in the computer NetBios name, they get the following error:"The Sql Server specified is either i....(more online)
Failed backup job - Hi,I schedule a backup job for one of my database every night. The database fails whenever a cluster failover of the server takes place.This is the error in the History Details:10 percent processed. [SQLSTATE 01000] (Message ....(more online)
How to create a new database from existing database in SQL Server 2005 - Hi everyone!I want to create a new database from existing database in SQL Server 2005. I need all the objects of old database as it is in new database. However, I have an option to take backup of that database and restore it ....(more online)
Restore log backup problem.... - Hi All,I have a database which takes the .TRN files from a log shipping pair and updates itself every 2 hours.when i restore the log files manually they restore fine but when i run it as ascheduled job every 2 hrs it fails an....(more online)
Restoring New Database - I have a new database that a developer sent from a backup he performed at their site called C.BAK. I would like to load to my backup server. What is the easiest way to successfully accomplish this? sql2d....(more online)
STOPAT CLAUSE DURING RESTORATION Command - Hi,I have my backup scheduled as shown belowat 9.00am -- full backupat 9.15am - Transaction log backupat 9.30am - Transaction log backupSuppose at 9.20am(say) the user deletes a table and i want to restore that particular tab....(more online)
Export data from SQL Server 2005 Express to Access database - HelloI have done so many times import/export using DTS package via SQL Server 2000. Today I have a request to export data from SQL Server 2005 Express to Access database. Do I have to install....(more online)
Reporting Services Error - SQL Server 2000, building an RS Report in Visual Studio:I suddenly get the message: "an error occurred during report processing.Exception of type Microsoft.ReportingServices.ReportProcessing.af was thrown."I receive this....(more online)
Permissions setup - I would think this would be a simple task, but its proving to not be so simple. Maybe I'm overlooking something.I have an sql 2005 server, on that same server and same instance I'm running a report server.I have an asp.net se....(more online)
Drillthrough parameters didn''t appear in the report - Hi all,I have created the ad-hoc report via Report Builder. I would like to define some parameters to my report, so I go to Report then select filter and double click at "Year" field which i would like it to be the parameter ....(more online)
reporting service error - when i run report in my machine it will run fine.but when i run on another machine bt giving my url address then it will give error: rsProcessing Aborted , report connection not set.so please help me i surch most option &....(more online)
CLR with SQL Server 2005 - Compatablity = SQL 2000 - I have a Sql Server 2005 Database that has it's compatibility set to 2000. I'm trying to create a stored procedure that references a vb.net assembly. I've gotten to the point where I'm creating my stored procedure and trying ....(more online)
CLR and Performance... - We have a programmer who has coded himself into a corner...and the only solution appears to be a CLR routine to be able to correctly hash the password so that both ASP and ASP.Net version of the code generate the same hash so....(more online)
database corrupted - Hi, I having serious database corruption issue. I tried dbcc checkdb ('dbname', [REPAIR_REBUILD]), but still no repair. I would really appreciate if anybody could help me to recover my data.DBCC CHECKDB gives the following er....(more online)
SQL Assistant & DBPro - We've been doing more and more of our development in the new Team Edition yada, yada, yada, what was called DBPro or Datadude. Regardless of the name, we've found it to be a terrific tool. Unfortunately, most of the thi....(more online)
Find if Cross-database ownership chaining is disabled - I am trying to write a sql query that would tell me if cross-database ownership chaining is disabled for sql server 2000/2005. If anybody could help me with this that would be awesume.-Kyle....(more online)
how to loop through all tables/columns to search for phrase - i'm trying to troubleshoot an SSIS package that is supposedly failing to import some records. i've been given details of one of the records it's supposedly failed to import. so, i've opened the db backup file on the day which....(more online)
Reporting Services Security Issue - I made a report on our database server. I am an administrator there and I can run report and I get no error. I created a group for that report called ReportUsers and I added one user there test_user. Then in the Reporting Ser....(more online)
Why does 64Bit Install Create Program Files Folder on Largest Drive? - We noticed SQL Server 2005 is creating \Program Files\Common Files\Microsoft Shared\DW on our largest drive for each 64-bit installation. Does anyone know what this is? It appears there is no Microsoft documentati....(more online)
DTS import Wizard- Where are the files stored - Have just imported my DTS packages from SQL 2000 into SQL 2005. I can see and run the packages in Intergration Services, but how do I edit them. I guess I use the SQL Server Business Intelligence Development Studo....(more online)
bcp TO SSIS - I tried to search this forum for an answer and I apologize in advance if my question has been answered 1000 times before.With that out of the way, I have a legacy system that produces bcp extract files & format files for load....(more online)
Data Transformation Task in SSIS - Hi,How I set the Transform Data Task Property in SSIS packageAs I designed SSIS where I mapped my text file columns to database table columns but if I selected wrong input text file having less columns than database table the....(more online)
Iterate over files in correct sequence according to creation date ?? - HiI'm using a ForEachFile iterator to iterate through a bunch of files in a specific folder. I need to make sure though that I iterate through the files in correct order - starting with the oldest one and ending with the last....(more online)
Error when the table has not created yet - Hello,I have created a package that check if a table exist otherwise it drop it, then it creates a new one (both with SSIS execute SQL task).Then a Flow task run some transformation SSIS to load the table just crea....(more online)
Error From ForEach Loop but Package Runs - Hello,Within a ForEach Loop, I have a Precedence contraint between two Data Flow Tasks where the Evaluation Operation is configured to 'Expression and Constraint', the Value = 'Success' and the Expression is as follows:@[User....(more online)
How can we delete duplicate records... conditions apply. - Hi ALL!How can we delete duplicate records from a TABLE in SQL ServerFollowing points are to be consider while writing query:Use of other table, temporary table, table variable is not allowed.Table has no primary keyExample:T....(more online)
TempDB CPU - I read an article about having TEMPDB file group for each CPU..We have 4 cpu on some servers but only one TEMPDB Data and Log is it recommended for me to add another TEMPDB ...If any one has done that i like to see how to do ....(more online)
user and login. urgent - Hi,we have one database with four schemasI want to create four user with database owner rights for four programmers, and track the performance of query based on their id and their connections.my question is, for tra....(more online)
Using fields containing comma seperated lists - I currently have three different fields of data that are varchar fields that contain a comma separated list of choices that a user can select.For the most part it does what it needs to since 90% of the time I just need to dis....(more online)
Joining Tables in Different DB''s - Does anyone have any ideas on how to join tables in different DB's without the possiblility of linked servers or replication? I am looking for something along the line of a Data Access Layer in .Net. ....(more online)
DTS/SSIS in SQL express - I currently have a customer who uses MSDE and has around 50 DTS packages importing data from a third party app into a SQL DB for reporting. The DTS packages are called by a VB app which is scheduled using windows scheduler.T....(more online)
SQL Server 2005 Express and BCP - Greetings.I have been working with BCP to import a csv file into a SQL Server 2005 Express database table. I'm using a non-xml format file. I have one extra field in the database table that is not in the csv file.....(more online)
connecting to SQL Server Express via ASP (classic) - Hi All,I'm having trouble getting at SQL Server 2005 Express via ASP code.I'm using the following connection string:Set objConn = Server.CreateObject("ADODB.Connection")objConn = "Provider = SQLNCLI;" & _ "Data Source = .\....(more online)
Advice needed - regarding data transfer between databases - Hello everyone,Here's my situation...I'm running a web service which involves 51 seperate servers and databases. There are fifty licensee servers (One for each US state) and one corporate server.Each night I ne....(more online)
replicate between 2 sql login database - I had 2 SQL2K5 on different site, can I repl/sync all SQL Login between this 2 box? Thanks in Advance. ....(more online)
Combining two varchar fields to one datetime - I know this is simple to you who have been around, but it is driving me buggy. I have tried a number of thingsHere is my varchar input:Date_Created Time_Creat20070606 1220562007....(more online)
Variable parameter lists in functions - I don't think this is possible, however I will pose the question just in case....I am converting a maths calculation engine into SQL. This is all OK so far, except when it comes to the use of aggregates. SQL uses aggregates o....(more online)
Can this query be optimized - Hi.......... the query that i have made calls the same table with condition 'processing_date <= @BalanceDate' in the inner query. This is taking a good amout of time. Is there someway that this query maybe optimized by rem....(more online)
Unable to execute dynamis SQL from within a UDF leaves me with a problem - Hi allI have a problem which would be easily solvable if I could execute dynamic sql from within a UDF. However, this is not possible and so I am wondering if anyone can come up with a different solution.Here is the problem. ....(more online)
Selecting last two orders - Hi all. I am having a brain meltdown. I am trying to gather the last two orders for a customer. Would a subquery be the best way to get the desired results? I have been trying to use TOP 2 in one query and various things in t....(more online)
Oracle Data to MS SQL Server 2005 - Guys,I need help in importing data from Oracle database to MS SQL Server 2005. Do any one know of the best way to go about this task? Is there any tool I can use to accomplish thsi task? ....(more online)
BlackBoxTrace - Hi allI've setup blackboxtrace on my servers a few months ago based on this articlehttp://www.sqlservercentral.com/columnists/bknight/blackbox.aspDoes anyone know how to stop this trace without restarting SQL Server? Tha....(more online)
Transactional Replication - I had setup a transactional replication in our environment with all the default article properties. All the objects on the subscriber are now created with owner 'dbo'. But on publisher there are some objects which uses d....(more online)
Cannot Connect to Server - This is really annoying me now! I have 2 SQL servers out of around 50 that I have trouble connecting to, the problem being I cannot create an ODBC connection using integrated security over TCP/IP. As soon as I change to named....(more online)
Restore Master Database to Test Server - Hi All:Please advise me about restore a master database from production to test server.The reason to do this because I need to test and evaluate some login in master database.I tried to restore master database to test s....(more online)
Internal consistency error occured. - I'm getting "Internal consistency error occured. Contact Technical Support for assistance. RESTORE DATABASE is terminating abnormally." when doing a database restore. My question is, can we do a backup on MSSQL2K with SP....(more online)
How 2 Use Same Database Maintenance Plan in Different SQL Server - Hello all,I have a little knowledge in SQL Server 2000. I am Administrating SQL 2000 Servers (running on Win 2000 & Win 2003 Server Systems) at 25 different locations. Everywhere I have to create Automated Backup Plan (fr....(more online)
Help identifying errors in DBCC command results - Hi all, i hope you can help here.I am seeing a number of issues when running DBCC command against a DB of ours, the upshot is the following error messages, could someone help in deciphering the results please, and I have very....(more online)
How to select rows from tables - Consider the following tablesMANAGERID 101102103104MANAGERID-------EMPID101 ----------------24101-----------------25101 ---------------....(more online)
PDF image on database - I don't know if this is possible.I am trying to build an stored procedure that will insert a PDF on an image column just with SQL, is it possible?The parameter on my stored procedure will be the path of the file.I am trying t....(more online)
DTS Package Owner Incorrect - Why? - We performed the following steps.Create a SQL Server login id named DTSUser with no database permissions.Connect to an instance of SQL Server using Enterprise Manager, with the connection properties of DTSUserOpen an existing....(more online)
Remove index ndf files - HiI need to move indexes back into the mdf files. My predecessor did this to improve performance but the plonker used the same physical disk. My Database is called WLR_England_15 and my index WLREngland_index. I've tried ....(more online)
40gig templog - What to do - This thread is related to a problem I thought I was having with locks, but turned out not to be the case.My real problem is something is writing to templog, as I can see it growing all last night, starting at about midnight a....(more online)
Performance Concern With Lock Pages in Memory Option - I ran across the following link regarding Lock Pages in Memory. The link is in the 2005 BOL, but my question is does it apply also to SQL 2000. The following statement has me concerned."On 32-bit operating sy....(more online)
Replication fails when Publishier''s field type is different of Subscriber''s - Try to do a snapshot replication. The field type on Publishier is char(1) and on Subscriber is varchar(1). The replication fails.Getting the following error:Error messages:The process could not bulk copy into table '"GRS"."GR....(more online)
Can I modify the Replication Job? - We don't have Outlook on our servers, and I want to add a step to the transactional replication agent job that on failure to use the standard SMTP sendmail sproc. Can I modify the job without killing the whole replication thi....(more online)
Multiple Publisher Replication - Hi,I'm attempting replication for the first time and would like some guidance from the experts, please We have 5 remote sites, each site has an application running on SQL Server 2000 with exactly the same struc....(more online)
Replication Alert Problem - 2000 - I'm trying to configure replication alerts in SQL 2000. I have several enabled and they have occurred in the Event Log but when I look under Replication Alerts in Enterprise Manager, they all say (Never Occurred) under ....(more online)
Applying sp3a after upgrading hardware in MSCS SQL cluster - I have been working on replacing older hardware in an 2 node Windows 2003 SP2 - SQL 2000 sp3a cluster:I removed one node from an sql 2000 SP3a cluster, built a new node, added it back into mscs, then used sql setup to a....(more online)
Copy db to another PC, then restore db, is backup history lost? - Hi, probably a dumb question but I am just picking up all this SQL Server stuff. A colleague has given me a backup up his db, I have restored it and that is fine. What I want to do ideally is restore it to a few days ago, is ....(more online)
Multi-part identifier could not be bound - Hello. When I run this query I got "The multi-part identifier gf.periodo could not be bound""The multi-part identifier gfdet.periodo could not be bound"Can anyone tell me what is wrong? Thank you.SELECT gf.periodo, gf.folio, ....(more online)
Querying (and then viewing) SQL Server data with user interaction - Hi Group,I am a newbie when it comes to SQL Server, but have some extensive db experience (desktop dbs, like Paradox, and some Access.) I have a need to create a stand-alone app that interacts with a vertical market software ....(more online)
Import Data From Access *.mdf Files to MS SQL SERVER 2000 - Hi all, I am having a few problems with our system the way its setup, but it cant be changed at the moment.We have a data capture system that picks up data from our machines and saves the data as an yyyymmdd.mdb file, this ch....(more online)
Unable to connect to Oracle using Microsoft OLEDB provider for Oracle - Hi everybody,I have designed a DTS package which will migrate a view from Sqlserver 2000 to Oracle.My package is using Microsoft OLEDB provider for Oracle driver for connecting to oracle.Im able to execute this package ....(more online)
remove by t-sql the cluster property - how can i remove by t-sql the cluster property from a CLUSTERED PRIMARY KEY field without droping the index?thanks....(more online)
how to pass coulmn values to stored procedure - Hi,I need to automate the procedure of selecting column with numeric and passing those column values as string to another stored procedure.My aim is to pass sitecode having difference <>0 and from date and todate as an ....(more online)
import data - Hi , i want to import the production copy on my local system.can somebody guide me on this. Thanks a lot....(more online)
View ?date modified? of all stored procedures - Experts,I?d like to know whether there is some way in SQL Server 2000 (using script or GUIs) to view ?date modified? of all stored procedures or some sp in a database. Please show me how I can do that.Thanks in advance....(more online)
sp_OACreate and MSXML2.DOMDocument.4.0 - SQL 2000I'm stuck on this issue and I cannot seem to find any resources. I'll try again here.Running the below script runs just fine if only running a few at a time. If I put this in a WHILE or CURSOR, it crashes ....(more online)
Pursuing 70-431 certification. What job title should I target... - I am currently reading through the MS Implementation and Maintenance book with the hopes of becoming certified as an MCTS for SQL Server 2005, and possibly heading into Business Intelligence and earning that certification. Lo....(more online)
70-444? - I am getting ready for the 444 exam. I bought a couple of books and so far this one seems fairly routine. I'd welcome some general feedback from anyone who took it.....(more online)
70-431 Microsoft Press Book frustration - So I have the 70-431 Microsoft Press book and the lesson questions are driving me nuts. It seems to me that half of the answers to the questions don't sound like they belong to the "choice" that was given. But I w....(more online)
SQL Developer Position in Cleveland Ohio - SQL Developer Cleveland Ohio.Salary range: 80-90K Company in Cleveland Ohio needs a strong SQL Developer.Cleveland area candidates ideally, but if you are close and willing to come to Cleveland, and RENT, those can....(more online)
SR. SQL DBA/Developer in Northern California - I have been hired by an exciting, fast paced company in the Vallejo/Benicia area to help them identify their next Sr. Database Administrator/Developer opening. This is a direct hire opportunity. I am seeking the be....(more online)
insert join???? - hello all, does anybody out there know if it is possible to do a insert join... Well ok I know that it CAN be done but somewhere I have gotten off then beaten path.I have a table (documents) and it has an ID field(GUID), then....(more online)
Is SQL aware of VERITAS? - Sorry, I posted this last week in the Backups section and received no response. I thought I'd try here.... I have a rookie question: We use VERITAS as our backup system that is controlled by another department. We....(more online)
1968 -
Database software pre-dates Dr. Codd and the 1986 SQL standard. According to Ken North in this paper (PDF), there were a great many people working on coming up with some sort of standard for storing and working with data.....(more online)
Die Access, Die -
I had to lead with this one because I have a similar view as this post. Access is handy, quick, does a few things nicely, but creates headaches and many more poorly written applications than I think are necessary. And why....(more online)
Blogging in your career -
I maintain a few blogs, well I maintain a personal one. The one here at SQLServerCentral.com doesn't get so much work, but I'm trying to get better at that. It's hard for me since this editorial is almost like a blog, so ....(more online)
Sprint's New Business Model -
In May 2007, J.D. Power and Associates passed out trophies to the nation's wireless service providers. Sprint Nextel came in dead last in customer satisfaction, receiving no acknowledgment whatsoever. Sprint CEO and Cha....(more online)
Vista -
I almost upgraded to Vista when I got a new desktop last year. I just avoided it because my machine was pre-Vista enough that I wasn't positive about the drivers, SP2 for SQL Server wasn't out yet, and I couldn't afford t....(more online)
MATRIX HELP SSRS-2005 - Hello,I?ve a problem with a report export.My report is a matrix, but the staticts columns (rows Groups) not have header (a column name, p. ej "Cliente"). look the example ....(more online)
Blank Page at end of report - I've setup my report to print a blank sheet after each group. This always gives a blank sheet at the end of the report - any way of getting rid of this? It's particularly noticeable when there's only one group on one page fol....(more online)
Few Questions on Report - I have a few questions regarding reports that I haven't found answers after a little searching. Thanks for any help!1. I need to create a few reports with some repeating pages. For example, in one of them I need to have a cov....(more online)
Exporting a report - Is there a way to export a report to a txt delimited (tab preferable) file? My output can exceed the 65,536 rows that Excel allows, so this format will not work for me. I also can't get csv to work wit....(more online)
Query execution failed for data set - I am trying to run a report in reporting services, I continue getting this error message: An Error has occurred during report processing. Query execution failed for data set ?releasedEncasementsSP?Could not find stored proced....(more online)
Many Intersection Tables vs. Many Entity Tables - All,I am interested in feedback on which of the following is the more efficient and better performing design. Please disregard syntax and datatype issues. This is only an example.Also, I am very much leaning towar....(more online)
How best to normalise a funding table - In my scenario, there are a number of distinct entity types, of which some are: PupilsCarers (parent, guardian, social worker)TutorsCoursesPupilCoursesSchoolsLocal Authorities (a.k.a local councils)Sponsors Each cou....(more online)
DTS Importing problem - I am importing a database from one SQL Server 2000 to another SQL Server 2000.The procedure fails with this error:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'view_ultima_avaliacao_todas'This error occu....(more online)
Job is showing executing status even though the log file is completed - I created job in EM couple days ago. It was running ok until yesterday. When run, job is showing execution status forever, but log file is completed with the last line: DTSRun: Package execution complete. Job owner is sa....(more online)
DTS Return Value from Stored Procedure - Help! - Hello,I have a stored procedure that creates a job and executes it. This job fires a DTS to be executed through DTSRUN.exe and it is all working fine except my return value is always "0" when I call EXEC @ReturnCod....(more online)
multiple domains in Idera?? - HiCan any one help to find whether Idera Sqlsafe will work in different domain...?In my office we have a sqlsafe respository and we have jobs running from diff instances with same domain...Now i'm planning do the same to my o....(more online)
DoCmd.TransferText acExportDelim puts quotes around all data - Why does the DoCmd.TransferText acExportDelim, , "dbo.tempSequence", "A:\" & RunsheetID & ".csv", False method put quotes around all the data? Help says you can create your own specification file by using the Export w....(more online)
display a tif file in a form - is it possible to display a tif file in a formand navigate through pages within the tif file?(the tif file is not stored as an image field but as a path to file on disk)thanks....(more online)
A Technique for Determining the I/O Hog in your Database - Comments posted to this topic are about the content posted at temp....(more online)
How to Choose the Best Connectors for SSIS - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/mfrost/3209.asp....(more online)
A Freeware offer for SQLServerCentral.com Members - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/pressrelease/3216.asp....(more online)
SQL Server Spotlight on Rob Zare - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/sjones/3215.asp....(more online)
| 
