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:
Job Tokens - $(ESCAPE_NONE(JOBID)) - I am having problems getting SQL 2005 to work with tokens.I am using the following in the last step of a job.EXEC sp_DBA_job_notification $(ESCAPE_NONE(JOBID))When I run the job it fails on step 2 with the message of, "....(more online)
Which SQL tool is better - We are considering to purchase some SQL tools. ERWin, RedGate or ApexSQL SQL tool. Can someone give some advice which is best? I used ERWin before, but not RedGate or ApexSQL. Thanks!....(more online)
Changing The Recovery Model - Hi,My company is running Win2K3 with SQL Server 2005 Enterprise Edition and the databases are currently set to have a recovery model of 'Simple'. I am wanting to change this to a 'Full' recovery model, however, before I....(more online)
Misterious Change of Compatibility Level. Very urgent! - Hi everybody:We have recently migrated our DDBB from SQL 2000 to SQL 2005 in several servers. We have 2 DB per server and the size of mdf file is between 10 and 40 GB.We put Compatibility Level in 90 in SQL 2005 bu....(more online)
New Database Operator - Hi,I would like to notify multiple users of events in MS SQL 2005.Can an operator be set-up with multiple email addresses, or is it better to have proxy access to a single email address amoungst a few users.Thanks,....(more online)
data page corrupted on datafile - Hi to every one,I have a case to recover database.case: i have a database HR. In HR database i have 3 file groups like HR_group1,HR_group2,HR_group3. in HR_group1 i have 2 .ndf files. in that two file(hrgp1.ndf,hrgp2.ndf) one....(more online)
Backup using Maintainence Plan fails - Extremely grateful for any help. I am trying to create a simple MaintPlan to back up a complete DB using the MaintWizard but is failing and I get the message below.Also the version installed is Sql 2k5 9.00.1399.06 (RTM). do ....(more online)
BAcks and log''s howmany how successful? - Hi not sure if I am in the right forum. I would like to know using TSQ how I can find what backups and logs have been performed in certain time scale. I would also like to have a few stats about them like length of time weath....(more online)
Backup and Restore as failover - I have backup and restore job for failover.First step of job to backup the production database and then copy the backup file to failover serverSecond step is to restore the backup file as read only on failover server (in case....(more online)
Reporting on data from three databases - I am trying to report on real time data from three different systems that all contain a subset of out asset managment system. Can anyone suggest a way of being able to pull data from all three systems and place into one repor....(more online)
Assembly location? - I was interested in finding out where the references are for the dll(s) our developers have created and installed, but now I am a bit confused. I did a query for the assemblies we loaded, select * from sys.assembly_files....(more online)
appending zeros to integer - MY client has a primary key field that uses integers as the primary key identifier. they want fileds that have less than 2 chars to be appending with a zero. So for the int field that is 0 that would like it to be 00 or if it....(more online)
Left function using openquery - Hello,I am hoping someone knows why I get this error when I use the left function in openquery to connect to an Oracle database.An error occurred while preparing a query for execution against OLE DB provider 'MSDAORA'. [OLE/D....(more online)
Identity columns and primary keys in a many to many example - I have a question on database design. I have 3 tables, a Vendor table and a Product table, and a many to many mapping table. each with 2 columns (id is int and identity and primary key)id, vendor name and id, product descrip....(more online)
Can''t connect to Reporting Services through SQL Server Management Studio And IIS - Hi,I'm getting the following error message when I want to connect to reporting services through SQL Server Management Studio. I have also check the reporting services configurations manager for any issues but still can't conn....(more online)
SQL2005 Query Notifications fire immediately - I am using the new SQL2005 feature of query notifications along with ADO.NET 2.0. I have this one server that it is not working on and I can't figure it out. The issue on this machine is not that the notifications....(more online)
IDENTITY_INSERT question - Hi all,Question for which hopefully I can get a positive answer, even if I know there is a little chance...The situation I am in:I needed to have a column in my table where the value will increment automatically,say:1,2,3,4,.....(more online)
One XP SP2 client won''t connect - I've been installing Interprise client on several machines around the office. All of them can connect to the server, except one. I took the client out of the loop, and tried to connect via sqlcmd on these machines. Again, ....(more online)
Configuring a Linked Server to Sybase - Pardon my ignorance but I've been at this for over a week and finally had to ask for some help.I'm pretty proficent with SQL and linked servers through different databases, but this Sybase has me stumped! I've tried hun....(more online)
Connections May Be Forcibly Closed... - Dear subscribers,Background: A previously working and unchanged SSIS package loading a moderate amount of data to a remote instance of SS2005 is now failing shortly after invocation with a message about the connecti....(more online)
Custom data flow transformation component designer - Hi,As far as I know it is currently not possible to add a SSIS custom data flow transformation component by constructing it in the data flow task editor directly.Is there some tool, designpattern etc that support this? T....(more online)
Reading backup package data - Given that maintenance plans in SQL Server 2005 are now stored as SSIS packages, is it possible to 'read' the SSIS package data to identify 'Back Up Database Task's, and work out what backup options are in place? T....(more online)
DTEXEC thorws error saying Argument "Excel" for option "connection" is not valid. - I have developed a SSIS package this runs fine in BIDS and even when i run through DTEXEC UI but when i copy the script generated by the DTEXEC UI and run manually through command promt ..... it throws me the below error. I a....(more online)
Passing a variable from ExecuteSQL task to Oracle OLE DB Source - I have created a Package ExtractDistributionRecords.In the Control Flow, I have an Execute SQL task that does a simple query to get the date that an extract last occurred. This date is stored in a little SQL Server tabl....(more online)
SQL Server Performance Dashboard on SP 2 - Does anybody knows or found out of any information relating to Performance Dashboard on SP 2 of SQL Server 2005? besides that of the download site from microsoft. I don't seem to find much of an info on this tool.....(more online)
Reducing Parallel Execution - I have inherited several jobs (>15) that seem to take forever to complete, even though they do not appear to be very complex. When these jobs run I've noticed that there can be up to 16 different entries for the same....(more online)
Hardware & RAID Configuration - What''s the best - Hi,I'm about to setup a new production enviroment which relies heavily on SQL Server 2005 Enterprise to manage a processing queue. There will be lots of BLOB data in a form of XML exchanges (a separated file was designed for ....(more online)
Hiding databases based on login - Hi - Does anybody know if it is possible to prevent a database from being displayed in object explorer if the user has no rights to it? We have a multi-client system and want to arrange that when SQL Management Studio is open....(more online)
"with grant option" does not work on database role? - Hello all,I've got a problem with the "with grant option" on a database role. All users who are members of a specific database role should be able to grant select permissions to other users. Unfortunately the "with grant opti....(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)
questions on migrating sql 2000 databases to sql 2005 - Hi all, We are plannig to migrate our sql 2000 databases to sql 2005. as a trial, I have set up a sql 2005 machine and restored one of user databases from sql 2000 to this sql 2005 machine. before I go further to follow the i....(more online)
Identifying the same table (after a rename ) in different databases. - Good morning,A while back I started working on some inhouse software for the company I work for to script the differences between our database and itself after a set amount of time. This was fairly easy and worked well. We ha....(more online)
Conversion failed when converting the varchar value - i try to run this simple query and recieved this message: query: select Debts.Balance * (-1) from debtsmessage: Conversion failed when converting the varchar value '2887.5 ....(more online)
Odd Problem - SQL Server Express Returns Different Records than 2000 - Hello,I've got a very strange issue that I'm hoping someone can help with.Basically, I've inherited an application that makes a call to a SQL Server 2000 database. If I run a simple query against the database like so using S....(more online)
Repllicate Table with no Unique ID - We are trying to implement Transactional replliation but our propery management system has some tables which they use for loggin and some tables dont have a uniqueId colum. This triggers an error in the replication proc....(more online)
SQL 2000 SP4 Publisher to SQL 2005 Distributor - Help! - Hi - hoping some folks here can help me. I've got a SQL 2000, Service Pack 4 database that I need to publish, but I'm getting the following error on the exec sp_addpublication statement when I try to set up publication in Ma....(more online)
HELP!!!!! Dynamic SQL needs converted to set-based solution - Here is my problem: I currently have a cursor-based solution to read from 3 different databases and merge selected data into one master. I am using dynamic SQL, but I would like to get away from that, if possible. Here is a s....(more online)
How to read XML through SQL Queries / procedures - Hi All,I have XML string stored in database column, by parsing the XML string I need to get some values into variables using SQL Queries / Procedures, Is it possible? Please provide the solution for this.Thanks in advance,San....(more online)
Calculating Median - Help - How do I calculate Median value for a set of records using a simple query.Thanks in advance for your help.San.....(more online)
Convert Function - Good Morning Everyone,I have stored salary amount as varchar in my table and now i need to convert into currency format with "$" sign. I have wrote following funciton to convert the datatype'$'+ Convert(varchar,Convert(....(more online)
best practice for returning when matching a MAX() - I want to return an different column for each row having a MAX(). There doesn't seem to be an intuitive way to do this. For example:select topicID, lastPosterIDwhere postDate=MAX(postDate)the problem comes in grouping. SQL....(more online)
Could not allocate space for object because the ''PRIMARY'' filegroup is full (maintenance plan) - Hi,I hope that someome could help me with this issue and give me some hints on how resolve it.The issue is with the job optimization. first, let me give you some settings :I have an application that have a db in SQLServer 200....(more online)
Moving SQL Jobs to Another Server - Hello All,I have moved a sql 2000 database to a different server, I now need to move all the SQL jobs and Maintenance Plans. How can I do this? What system tables must I replicate? They need to go from one 2000 box to another....(more online)
Can the polling sessions cause a server to crash - I have multiple SQL servers 2000 registered on my Enterprise manage, I actiated the polling to check when the SQL Server agent goes down, but my polling is causing numerous log files to be generated on the WINDOWS 2000 Server....(more online)
SQL Server reporting did not run - Hello All,I am newbee to sql server 2005 report services. I am runnning into sql server2005 report issues when I enteredhttp://servername/reportserver. Reporting Services Error An internal error occurred....(more online)
birthdate as a non date field - if you had the option beforehand, and you know going in people are only going to give you (on occasion) partial birthdays, would you or would you not break up the birthday into three seperate fields just to be able to ta....(more online)
data overwritten in some records - We have recently had an issue where some fields are being overwritten in the SQL Server 2000. The data is in the form of a string and depending on which field is being overwritten they are between 18 and 76 charac....(more online)
System Crash - I have SQL Server 2000 installed on Windows 2000 Server platform. Now suddenly the operating system crashes i.e. it doesn't boot. The OS was installed on C: drive and the SQL Server database is on D: drive.I have installed a ....(more online)
data migration - I have an excel sheet and I am migrating it to another system.During course of migration if business people come and say that some more changes need to done to the excel sheet,how should such kind of things need to be handled....(more online)
What do you use to track user requests? - I'm curious how other people track DBA-resource requests. We receive requests from developers and users in the form of emails or phone calls, but currently do not track the quantity or type of request, including time sp....(more online)
SQL Profiler Events: The difference between Object:Deleted and Audit Object Derived Permission - I have SQL Server 2000 with Sp4. Could somebody explain the difference between the 2 SQL profiler Events. 1. Objecteleted : Indicates that an object has been deleted, such as in DROP INDEX and DROP TABLE statements....(more online)
Recursive trigger ? - I have a table with the same structure on two different servers. If any update is done on Server A (SQL 2000), the data needs to be copied over to Server B (SQL 2005 Express) and vice versa.This is a small table with 10....(more online)
Schema Migration Test Tools - I am testing an application that is migrating to a new schema. I have to ensure that data that was in the previous schema is available in the new one. I've found tools that allow me to compare table/table and view....(more online)
SQL Server 2000 Cluster installation on Windows 2003 fails - I am trying to setup SQL Server 2000 on Windows 2003 R2 (SP1). The installation fails after I give all the required information. The sqlstp.log file has the following entries. 16:37:19 Setup is performing required operat....(more online)
The File Placement Dilemma - We have a 45GB database heavily used for both for OLTP and batch processing. As usual, a small percentage of tables are responsible for most of the impact in terms of size (in some cases tens of millions of records) and frequ....(more online)
SQL 2000 - Performance suggestions - I have a customer using SQL 2000 Developer Edition on W2003 Std. The server has 2 x 3.75Ghz Zeon CPUs with HT enabled, 4GB RAM and a 400GB Raid 5 Array. The database in use is just under 10GB in size (SQL is configured to u....(more online)
SQL Server performance -Memory,CPU - I usually faces the problems like sql server is taking more memory or CPU usage is high due to sql server , and i checks the parameters like 1)whether AWE is enabled ?2)whether parallelism is enabled ?3)Is ther any blocking ....(more online)
MSDE database queries - intermitent performance issue - Need some help with this one.My company has developed a software suite that includes an MSDE database. We use a common 'meta data' schema for all our solutions and have many customers using this common schema. One (and only o....(more online)
Troubleshooting of replications - I would like to have some articles about what to do after configuring replications, such aswhat to do if we change articles,what to do if we restart a server,any other troubleshooting.Any input will be greatly appreciated.&nb....(more online)
During Configuring of Publisher, get error : cannot copy distmdl.mdf to distributor.mdf - I can configure on my machine for Replication where I am an administrator. On the Server I am not. What rights are required on a server to go through the configuration process without a hitch? I'm using Sql server 2000, sv pa....(more online)
Odd Question - Backup SQL server was down for a while and now we are bringing it back up. On its way back up, we removed log-shipping, as we were going to have to re-do them anyway. Now when I try to re-register the server, it i....(more online)
SQLServerAgent will not connect HELP - In the event viewer I see this error message. Can anybody help with this. I am completely new to this and need help.SQLServerAgent could not be started (reason: Unable to connect to server 'CHARLEY\ACT7'; SQLServerAgent canno....(more online)
Using Conn.Execute() in an ASP file - Happy Friday Everyone,I am having trouble finding an answer to this question so hopefully someone has it, can answer it, and we can move on. I have created an ASP document that interacts with my SQL2000 server database. At th....(more online)
Purging the old Transaction Log files - Hi,In one of our DR Servers we have configured Custom Logshipping. In the folder where the .TRN files are getting copied there is a script to purge the files which are older than one day. Following is the code for the s....(more online)
GROUP BY - Hello, I hate to ask such a simple question, but here it goes.Suppose I have a table such as:SERVER_NAME DATABASE_NAME SIZEA ....(more online)
SQL Server is not returning all records from ORACLE - Hi guy, I have a problem with oracle ODBC driver 10_2 on my SQL Server 2000. I linked table from oracle but is NOT RETURNIG ALL RECORDS. If I do the "Select COUNT(*) FROM.." number of records come exact number, but when I use....(more online)
osql Cursor values to output file - guys,I have following stored procedure which runs osql cmd to write to a file every next value of a cursor, but the problem is the file is overwritten for each value of the cursor. Is there any way to modify the stored proc t....(more online)
DML Timestamp - Guys,Is there any way to get timestamp of the last DML - delete, insert, update operation performed on a table. I tried 'sysobjects' it only holds create date 'crdate'. To get around this I have added new columns DATE_TIME_CR....(more online)
ASCII Characters? - Hi Guys,I need to pass a ASCII character to a stored procedure as it uses this char as a seperator. The vb that currently calls the procedure uses this function to define the seperator Chr$(1) this evaluates to something like....(more online)
Change the date format - Hi All,How could I change a datetime field to the following format?YYYYMMDDHHMMSSThanks in advance....(more online)
import csv file by calling store proc - Hi, I need to create a small program to import csv file and export it back with fewer data. For example when we import file contains A-L, when I export back only A,C,F,H How do we import csv file in SQL s....(more online)
Great SQL DBA Position in Indiana - Well Established Company in Evansville Indiana needs an SQL Server DBA to join it's staff.Evansville is geographically located near the nation's population center and is less than 200 miles away from four major U.S. cities (1....(more online)
Entry/Junior Level position in our Business Intelligence Team - We are looking for a motivated self learner that has a desire to work in a cutting edge Multi-Dimensional Analytics field using Microsoft?s BI tool stack. You will be working with some of the best in the business of ret....(more online)
SQL Server is not returning all records from ORACLE - Hi guy, I have a problem with oracle driver 10_2 on my SQL Server 2000. I linked table from oracle but is NOT RETURNIG ALL RECORDS. If I do the "Select COUNT(*) FROM.." number of records come exact number, but when I use "Sel....(more online)
Vista upgrade from previous Windows''s - I know that some members are running Vista, but has anybody done an upgrade from 2000 or XP to Vista, as opposed to buying it preinstalled on a new PC?As a test, I did a reformat & then a clean install of Win2K, then ....(more online)
Do what I said? - I want to know if your manager tells you to do something and you know it is not right, will you do it?For example I used to work for manager who insisted to have the job start running at 6:00am, the job was running a DTS pack....(more online)
Portability -
I saw this article by Ralph Kimball on OLAP v relational structures and I found it very interesting. One of the prominent proponents of data warehousing and OLAP structures takes a look at the pros and cons of using eithe....(more online)
The Certification Debate -
Is it worth getting certified? What do you get out of it? I've noticed a few debates on the site, and many threads asking about the exams, preparation, and even requirements for certification. Since we're primarily a lear....(more online)
The Cult of Mediocrity -
Hey, did you hear the one about the two brothers who spent years trying to make a bicycle fly? Or the guys who started a major computer corporation in their garage? Or the guy who dropped out of college to start one of th....(more online)
Challenge Yourself -
Last week Andy Warren wrote a great article called revisiting what you know and it got quite a few interesting comments. The gist of the article is that many of us learn certain tenets and techniques because we have to, j....(more online)
SQL Server 2000 Enterprise Manager Snap-in missing - After running virus cleaning software on my HD, I suddenly find my Enterprise Manager snap-in missing and fail to initialize. Is the MMC erased or damaged? What should I do? Reinstall SQL Server 2000 and/o....(more online)
SQL Server 2005 report did not run - Hello All,I am newbee to sql server 2005 report services. I am runnning into sql server2005 report issues when I enteredhttp://servername/reportserver. Reporting Services Error An internal error occurred on th....(more online)
Cannot install SSRS 2000 on 2003 Server 64bit? - Hi,I can't get SSRS server to install on Win 2003 Server R2 64bit. The install barfs with a dialog 'ASP.NET is not installed or not registered with your Web Server', if I continue I can only install the client components. The....(more online)
CRM 3.0 Physical Model - I'm just getting started with Reporting Services. My company just began using CRM 3.0 a month ago. I found Visio files of the database Logical model on Microsoft.com but I'd really like to see the physical model -....(more online)
Batch Printing - Hello There! In my minds eye, this is a tricky question. Maybe I'm making it harder than it actually is, but I am near stating that SSRS is incapable of producing the following request.I have created a report that takes in a ....(more online)
Cross domain authentication SSAS - Hi I am using SSAS 2005 in a domain AAA and SSRS 2005 in a domain BBB.I am not able to authenticate users across domains , SSAS uses windows authentication and since the domains are different I am not able to connect my datas....(more online)
Non-auto parameters in MDX Queries and SSRS2005 - I wrote some reports in SSRS 2000 against Analysis Server 2000. I've since upgraded to AS/RS 2005 and am struggling a bit with the MDX query builder.In 2000 I was able to (nay, forced to) put my parameters into strings into ....(more online)
analysis services 2000 cant access registry issue. - I recently had to reinstall AS2000. Since then , if i dont run the service under the local account i get a "could not access registry on (localserver) or analysis you are not part of analysis server admins.I am in the sql ser....(more online)
Job executing DTS Package Failing - I have created a DTS Package that executes a Cube rebuild using the OLAP Object. This Package resides on the STRVBIP01 SQL server, and works when I execute as a DTS Package. However, when it is scheduled, I get th....(more online)
Invalid status for bound data - Hello, We are seeing the following error during a DTS execution and do not know what is causing the problem. We are connecting to an HP-NonStop via an ODBC driver and extracting data without transformations. The package sta....(more online)
Passing date parameter to Execute Process Task (batch file) - I have an existing DTS application into which I need to add some functionality to copy latest images which are held on a remote server. In DTS I have set-up a SQL query to retrieve the last date that the copy was successful f....(more online)
Relationship between a data model and an ''analysis'' model? - Does anyone have the patience to explain what fact tables and dimensions are? I have an idea and am very familar with the basics - tables, joins, queries. Why are these terms slightly subverted for analaysis & business servi....(more online)
Shrinking Database Using DBCC SHRINKDATABASE - I am trying to shrink a database using DBCC SHRINKDATABASE and am getting the following errorCannot shrink log file 2 (<dbname>_Log) because all logical log files are in use.Anybody know what to do to correct this error....(more online)
Looping through DB to get tables - I am new to this so please be patient, but my question is i use oledb to connect to access database and that works fine, my problem is that i need to loop through this database with all tables that end with the word Data. I c....(more online)
Migrating data from Access to SQL Server 2005 - My problem is that I have to migrate several tables from Access to SQL Server 2005. Those tables come from Excel, which are converted into Access and then, my idea, is to migrate them into SQL. One important point is that I n....(more online)
Show many shades from the 1 product - Hi Can i get a help with my many to many relationship where i have products and shades.A product can have many shades but not of the same colour.So far i have a form where i can enter in products and a shade if the ....(more online)
Logging in Access to SQL Server 2005 - Hi all, We found an expression to login Microsoft Access to SQL Server 2005, but are unable to figure out where to insert it to actually make the connection. Does anyone have any experience in this? Thanks,Taylor....(more online)
how to do math on nested queries? - i tried googling for this but couldn't find it, and not too sure if i'm searching correctlyi have 2 tables (tblTraderPnL,tblTraderFees)what i want to do is take the sum of the PnL, and the sum of the fees, to come up with one....(more online)
Revisit What You Know - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/awarren/3119.asp....(more online)
Professional Development Plans - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/awarren/3134.asp....(more online)
The T-SQL Quiz - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/gFritchey/2973.asp....(more online)
A Simple Approach to SQL Server 2005 Encryption - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/mgood/3058.asp....(more online)
Writing Maintainable Code - Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/pabdulla/writingmaintainablecode.asp....(more online)
Ten Reasons to Attend the PASS Summit - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/pressrelease/3149.asp....(more online)
| 
