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:
SQL Operator Email/Net Send History Wrong - I've got alerts set up on a SQL 2005 Enterprise install (latest service pack) and my operator histories are showing that though they've never been emailed, they've been notified via net send. HOWEVER, I do not have net send ....(more online)
Could not start the Oracleora92Agent service on Local Compute? - I have problem to start the Oralceora92Agent service. I don't know what the Oracleora92Agent service for and it will be an problem with this service not start or not. thanks....(more online)
Sqlservr.exe doesn?t free the VMemory Size - I would be very pleased if anyone could help me by giving me a short explanation about could be happening to one of my servers.Once i login in the server i have a look at the taskmgr and what i can see is that the sqlse....(more online)
SQL 2005 problem - I have a problem with a new install of SQL server 2005 Standard SP2 on Win 2003 server, x86_64, 8GB, 4 CPU. There's no RAM limitation for the SQl server as 64b.The server behaves very strange. Compare to install of SQL 2000 o....(more online)
SysThread ... woken up prematurely - I can't seem to find anything on this error message?. 2006-06-23 04:03:10.29 spid51 SysThread 0x7FF96E38 woken up prematurely2006-06-23 04:03:10.29 Server SysThread ....(more online)
backup error - Hi ,when i am restoring the diff backup i got this error.can u help me most urgentMicrosoft SQL-DMO(ODBC SQLState:42000)The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequ....(more online)
Manually run a backup to a network sharepoint? - HiI am simply trying to run a backup to a network sharepoint.I have mapped the drive, Z:\Bob, but I am not allowed to browse to it when I am looking for a location.I attempt to force it with \\Bob\Backup.bakBut I get an acces....(more online)
How to get date of last restore - I'd like to grab the date since the last restore but I don't see anything obvious in the system views. Please let me know if any of you have any suggestions or sample scripts. Thanks.....(more online)
Standby/Read-only DB state - Hello,We are using SQL 2k5. One of the DB is restored to a reporting server every night and is always in 'Standby / Read-only' mode.What I want to achieve is to use DBCC SHRINKFILE to shrink the log file after the DB is resto....(more online)
backup going forever - Hi,i started a full database backup job for a very large Database around 500 GB. When I go to SQL management- JObs and If I refresh over there I still see the status of the job is still executing. It has been more than 24 hou....(more online)
Transfer reports built by Report Builder - We're moving the SQL 2005 Reporting Services Server. Users have been saving reports built by Report Builder on the old Reporting Services server over the years. I have full admin rights to both the old and the new server. I'm....(more online)
Cannot retrieve row from page (1:2108289) by RID - MigrationData is my production database last few days i got the error message when i execute a procedure on this database, although i have installed new service pack 4 for sql server 2000.also i have recreated a new dat....(more online)
one database or another - One of the items that my client wants is to have data sucked out of the as400 into sql server. The data in the 400 is really bad and does not contain a lot of primary keys and there are other problems so some form ....(more online)
Issue while running upgrade advisor on remote server - Hi, While connecting remote SQL server through upgrade advisor I am getting the below errors:Error: Unable to connect to server. Reason: An error has occurred while establishing a connection to the server. When co....(more online)
Cannot Disable Trigger (Locking Possibly) - I'm trying to disable the trigger that updates a search table which takes part in a push replication. There are bulk operations (insert/update/delete) happening on the table through scheduled tasks and different applications.....(more online)
Impact of images on the transaction log. - Suppose I have a employee table such as :TblEmp(id int,date_joined datetime,dept int,emp_photo varbinary(max))If I have a transaction like this:begin trans update TblEmp set dept = 100 if some_value = true commit tr....(more online)
Reporting services, Stored Procedures, "Nested" tables - I was given a task to convert existing reports from classical ASP.NET into Reporting Services. One report actually contains data from three different tables:ORDER_HEADER order_id | customer_name | order_date1 ....(more online)
Connection Manager passwords - This has probably been covered but, I can't seem to find the info in my searches.I have a connection manager to connect to a DB2 database in my package. Unfortunately, my company has never seen fit to provide an automation ac....(more online)
Parent package - hi,is there a way to find out if the current running package is called/executed from another package using (Execute package task) or is being executed of its own.CheersDeepak ....(more online)
Package Storage - MSDB via File System - HiI'm wondering how people have chosen to store their SSIS packages - file system or in msdb? From what I've found it seems that both methods work well. File system seems to be slightly easier for editing and changing package....(more online)
dynamically assigning file name as an mail attachment - Hi all, Can you please send me code sample to dynamically assign file name - which I have to send as mail attachment. vcFilePath is the variable declared in SSIS which store network pathvcFileName is the variable declare....(more online)
Script Task - SSIS - Hi,I dont wish to use a data flow task just to use the conditional split...Instead I want to form a script in the control flow which will disable/enable tasks accordinging to what the variable is set when an sql task is execu....(more online)
Why the difference in execution plans between development and production servers? - I have just re-wrote a stored procedure that was using a datediff in the where clause so that it now doeswhere Stamp>@SearchStamp AND Stamp<=@SearchStamp instead of where datediff(day,Stamp,@SearchStamp) = 0as the Execu....(more online)
"Governor" for select sql applications? - We have 1 big developer box used for both Datawarehouse and regular dev. When the Datawarehouse guys get going, they really dirve up disk utilzaiton causing the other developers to complain about slug....(more online)
performance Issue with input variables - select count(*) from products where prodID between 20987 and 21003godeclare @ProdID1 intdeclare @prodID2 intset @ProdID1 = 20987set @prodID2 = 21003select count(*) from products where prodID between @ProdID1 and @prodID2First....(more online)
query spiking CPU to 100% - upgraded one of our servers to sql 2005 SP1 a week ago and we have been troubleshooting performance problems ever since. so far we have narrowed it down to 2 queries. this one spikes our 8 900MHz CPU Compaq server to 100% for....(more online)
Documents in VLDB - Hello All, I have been experimenting with SQL Server 2005 partitions. I loaded a terabyte of information into 2 tables. The first holds the document information and the second holds the actual binary document (in this ca....(more online)
Connection to database using NT authenication outside of our network - Due to SOX, we have need to use NT authenication for users that does not sign onto our domain. They will be connecting through VPN. How do we go about handling this?....(more online)
List Server Roles - I am currently working on a SSIS configuration database. However, I am having trouble writing a script to get the the users that have each server role permissions. I'm pretty sure that I need to use sp_helpsrvrole....(more online)
Case-sensitivity of login names - Hello there,I am wondering, why SQL Server 2005 (9.0.3042) behaves differently on two separate installations.On both machines I have defined logins, which have upper-case names ("TESTLOGIN"). I can connect to the databases us....(more online)
BEST PRACTICE ON PRIMARY KEYS - I have to use primary keys but they seem to be a bit lenghty.However they all provide meaningful Identification especially at the database level.They are not friendly especially on application side in searching,retrieving rec....(more online)
back Out Plan from 2K5 to 2K - What kind of back out plan should be employed to apply transactions/data differences made in SQL2K5 back to SQL2K should we decide to back out and flip our switches back to SQL2K? Detach and attach? Restore?....(more online)
sql server 2005 express installation - i am using p4 3gh processor, 945 intel mother board, 512mb,160gb hdd, on board 10/100 mbps intel pro lan ,os is xp -service pack-2.while i am trying to install sql server 2005 express it is giving the warning message sy....(more online)
how to get the number of rows exported through bcp - Hi,I need to be able to output the number of rows exported through bcp to another file. Is there a simple way to do this?The current code is as follows:DECLARE @sql varchar(8000)SELECT @sql = 'bcp "exec stored procedure....(more online)
finding non alphanumeric characters - Anyone have a good way of finding non-alphanumeric characters in text/character fields without having to do a query for every possible one a user could input?It has to be handled at ETL time since the CMS is not capable of pr....(more online)
Why does this stall? - HiFirst of all, I'm very far from being an expert on any SQL at all, so my code probably looks unnecessarily complicated and this is probably a newbie question, even if a bit of a hassle to solve...I am limited in the respect....(more online)
CDOSYS Mail Failing outside my domain - Hoping someone could point me in the right direction. 1) I had set up a sproc to send email alerts using CDOSYS (based on a handy script from SQLServerCentral). Recently, the emails have started to fail if t....(more online)
Nested '' '' String Query - Hi,I am writing a query where I need to set a variable to a query string for example;SET @QueryStr = 'Select * FROM table1' this is OK and works fine, but I need to nest additional ' ' as part of the where clause to fin....(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)
Tables with Foreign key reference - Hi guysI'm having a headache with deleting a table with foreign key reference. How can I delete from the table because I know truncating is not possible, i've tried no check but still no luck.M....(more online)
A decent inventory - I'm working with several named instances on stand-alone servers and clusters.The amount of databases and instances continue to grow, and therefore I'm looking for a decent (low-level) database inventory system. The use is for....(more online)
Reindexing and recompiling - HelloI have set up a process that reindexes tables where ScanDensity <75 or LogicalFragmentation > 10. This is working fine. My question is having run DBCC reindex on the tables is it then necessary to execu....(more online)
Data Fetching Error - MigrationData is my production database last few days i got the error message when i execute a procedure on this database, although i have installed new service pack 4 for sql server 2000.also i have recreated a new da....(more online)
Help on deleting old backup files - Can anyone tell me the parameters used in xp_delete_file.I have the xp working and can delete backup files older than 7 days in a folder.In particluar I am looking for a paramater to enable me to delete through all the subfol....(more online)
Large Transaction log Backup failing with OS error 33 - We have a SQL 2K DB running on Win 2K that is about 45GB the DB is in Bulk-Logging mode. We have started running some jobs that cause the Transaction log to grow quite large 20-30GB. We have started seeing some problems....(more online)
SUSPECT database - Hi, My laptop hanged as I was running a large table update and when I restarted my database was marked as 'SUSPECT'.Running sp_resetstatus @dbname = "mydb" says that the flag has allready been reset but does not make an....(more online)
Is this type of trigger on a view possible? - Hi to all,just a quick question.Is it possible to have some live check on a view that the instance any data is present in the view a store procedure is invoked.e.g. if i have a customer list and a view on a report which conta....(more online)
Confused by article in sqlservercentra.com ? - Hi, I m little bit of confused in an article in sqlservercentra.com at this link:http://www.sql-server-performance.com/performance_monitor_counters_sql_server.aspWhich says :If you find out that the number of page splits is h....(more online)
Querying the max row length - Hello everybody,I just started at a new customer site and discovered that they have lots of tables the the theoretical total lentgh of a record can be over 8060 bytes. Some tables have up to 8 nvarchar(2000) columns. So far t....(more online)
Looping steps in DTS - 2 steps waiting causes error - I keep getting an error since I am setting two steps waiting (one the active task i'm on and the other the one i have to back to in the loop). How do I loop back to task 3 and keep the task i'm on waiting?Thanksmathjon*....(more online)
can not telnet to sqlserver 2000 personal edition - Hi,i have installed sql 2000 personal edition on win xp, and i can not telnet to the localhost: telnet localhost 1433the query analyser works fine.Can anyone help me with this problem?tnx....(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 2000 using profiler for disk reads tuning - We have a large db with a ton of online queries running. We have been looking at the SQL statements for index tuning already. What I want to know is how to use profiler to see if there is i/o disk bottle neck. I have do....(more online)
Optimizing Performance of Stored Procedures in SQL Server 2000 - Hello All,I need some of the expert advice on a situation I'm facing.We have about 240K Customers in our database. We created a Customer Segmentation process to segment our Customers in their proper group and then do targette....(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)
Enable auditing on a replicated table - I have a requirement to enable auditing on a replicated table. To acheive this, I have created 3 procedures [one each for update, insert and delete] that would insert the records into an audit table before the transactions ar....(more online)
Guest Account SQL Server 2000 Master db - I have a question regarding the Guest account and the Public role in the Master database.I've removed the Guest account from all the databases from which it can be removed, except the Master and tempdb dbs. The default d....(more online)
login management - Im using SQLServer 2000 sp3a (old I know) and I'm new to my DBA job. One thing I've noticed it that domain logins accounts still show up as active in enterprise manager even though they are disabled or deleted in Active ....(more online)
setup kerberos authentication for SQL Server 2000 - Hi,I need some help to setup Kerberos Authentication for SQL Server 2000. I believe by default Window authentication in SQL Server is Kerberos. But I don't know enough and have not come across any documentation th....(more online)
Read File transformations error in package - I built the following DTS package http://www.sqldts.com/304.aspxin SQL Server 2000, but when exexcuting the package I recieve the following error with the first Step "Set Things Up"Step Error Source: Microsoft Data Transforma....(more online)
BCP Bulk insert from an excel file - Hi,Is it possible to bulk insert from an excel file (after converting it into a txt file).I tried it but could not succeed, can anyone suggest some way for it....(more online)
Data mining - I'm starting the developpement of a brand new version of an in-house application. One feature that would be incredibally usefull for the users is to be able to have a way to question the system. For example : From ....(more online)
Is it considered good practice to have one database file per cpu? - CPU (I didn't know there was a length limit for subjects!)I came across this blog entry from a (former?) Microsoftie who suggests that it is a good practice to have one database file per CPU, so on my quad boxes, I should hav....(more online)
How to find the childrens path of a given parent - consider the following scanario of categories tableCatID ParentID CategoryName---------------------------------1 0 &nb....(more online)
Attendance Report Query!!! Need Help!!! - Hi All, I have a view which has the below like data as output http://www.nopaste.com/p/a1umSHdBx/txt I wanted to represent this data li....(more online)
CHARINDEX - CAPTURING TEXT TO LEFT - Hello -Is there any way to capture all the text LEFT of the CHARINDEX character in a text string, dropping everything on the right?I've been reading through everything for days and days. If it's not possible, could anyo....(more online)
sp_add_jobstep - Can a variable be passed to the @command line? If so, how?Here's a portion of what I have:DECLARE @UserToFind varchar(30), @NewUserName varchar(30), @JobName varchar(30)SELECT @UserToFind....(more online)
Optimizing Performance of Stored Procedures in SQL Server 2000 - Hello All,I need some of the expert advice on a situation I'm facing.We have about 240K Customers in our database. We created a Customer Segmentation process to segment our Customers in their proper group and then do targette....(more online)
Being passed on after an interview - I've been in a hiring position for the last 5yrs and the #1 thing that irritates me more than anything is when a candidate sends a sarcastic or off color email after being passed on. (ex: explaining to me that I a....(more online)
Weirdest interview question? - I'm sure I'm not the only one out there who's been on an interview and been asked a question that seemed really strange. So I figured I'd put this out there to see what other odd questions have been asked at interviews.....(more online)
Opening for SQL DBA in HP [Hewlett Packard] India - Hi Folks,Currently we're looking candidates for SQL DBAs, Oracle DBA, Windows Administrators, Unix Administrators, Storage Administrators and Citrix Administrators. You can forward your resumes to jayakumar.krishnan@hp.com or....(more online)
Cannot get SP with 2 Outputs to work - This is my first attempt at writing a SP. I am using SQL 2000 with VB.Net 2005. All I am wanting to do is pass from a login is the username and password. Then return back whether the password was correct or not, and if so,....(more online)
Passing a stored procedure parameter into an IN clause - Hi All I have a stored procedure which, initially, I had passed a single parameter into a WHERE clause (e.g ...WHERE CustomerCode = @CustCode). The parameter is passed using a DECommand object in VB6.I now require the sp to r....(more online)
data alignment - Thanks In advance.I'm writing a report using VS2005 CR and I find myself stuck. I have data in a table that looks sort of like this:id user test grade status statisfy1 12 pretst 30 complete good2 12 posttst 50 inco....(more online)
c# question - Why we don't instantiate the string class in c#?Any answers will be appreciated....(more online)
XML file conversion to text - hi can somebody help me out in getting the column headers through xsl filefro example i have a following xsl file below is my xsl file<?xml version="1.0"?><xsl:stylesheet version = "1.0" xmlns:xsl =....(more online)
The July Car Update -
As many of you know I like cars. In fact, driving my car around Denver to get to baseball games is almost as much fun as playing. So this month I went to the UK, really just Cambridge, to visit Red Gate and of course I pa....(more online)
Tape Wars -
Tape still triumphs, at least it few a few months back at a storage trade show. I still believe in tape as it's got one big advantage over disk. It doesn't require power to keep around :).
I guess it's cheap on a per b....(more online)
A Cool Perk -
Years ago I made an effort to ride my bike to work in Virginia. I had a nice 12 mile ride from the house down back roads that weren't too heavily traveled. However with rain, kid emergencies, etc., I didn't want to be stu....(more online)
Mission Critical -
I used this blog post a little while ago as a starter to relate a story in my career. However I didn't really address the story in the post, so I'll do that now. In the post management doesn't want to upgrade email server....(more online)
Hard at Work -
I have a great job. I tend to work a 40-45 hour week, flexible, at all hours of the day and night, and seven days a week, but it's on my schedule and I rarely have any time-sensitive work. So I can delay something for a f....(more online)
Subscriptions have stopped working - We have several in-house generated management reports based on our trouble-ticket system. The support manager is making changes to the ticket system thata also changes the underlying database, to the point that she recently b....(more online)
why parameter inclusion causes less records - My question is why does the inclusion of my parameter, @GL, cause my report to only show records where the LEFT OUTER JOIN to the GRPLDR table is NOT NULL from tblMain.Basically, with the parameter in the report, I get 6 page....(more online)
Creating Subscription from code - Hi, I have a report that prints a briefing document. The briefing documents are stored in a database. When a document is inserted/updated I want to run the report to render that document to a .pdf on a fileshare. I figure a t....(more online)
Reporting Services Security - We use a reporting product called Actuate. Actuate has a feature called page-level security. Basically, page-level security works like this:A user would login to view reports. The user's login....(more online)
Stored Procedure w/ multiple result sets - Can SSRS handle a Stored Procedure with multiple result sets? I have a SP that looks like this & returns two results, but SSRS only sees the first result set.******************************************Create procedur....(more online)
Interactive Sort not work with cached/snapshotted reports?! - It appears that the interactive sort only works if a report is not set to be cached or viewed from a snapshot in the execution bit of its properties. Is there any way around this, preferable other than duplicating all the rep....(more online)
OLAP cube output to Excel sheet template - Hi EveryoneI need your help. I have manage to create olap tubes which work just fine. Now, my problem is when you extract some data out of it the user must copy and paste in excel and try to modify the rows and columns put ti....(more online)
Microsoft JET Database Engine - When I try to Export data from a table into a locally residing Microsoft Excel, using DTS Import/Export Wizard.I get the following error MessageError Source: Microsoft JET Database EngineError Description: Not a valid passwor....(more online)
DTS Package Execution (From Job) - Hi, We have DTS package which imports data from an Excel file into an SQL Server 2000 table. The DTS package runs fine when exectued from SQL Server Enterprise Manager, but when we run the Package from a Job....(more online)
Transferring data from AS400 to SQL Server - Hi all, I am working at insurance company that using AS400 as it main server. All transaction data is already kept for about 10 years (or even more..). This data is growing larger from time to time, and after several upgrades....(more online)
Import multiple Excel Files into exciting table - I shall explain my situation (SQL 2000)I have a folder A, which contains excel sheets with the following name Services wXX.xls, XX stands for the number of the week.Now I want to import all these excel sheets with the differe....(more online)
Importing data from SQL2005 to SQL200 - Hi, I have an operational system running on SQL2005.The data warehouse, reporting server and anaylsis services all run on SQL2000 on separate tin.I want to copy data from the 2005 database into the 2000 database periodically ....(more online)
Upsizing Wizard skips table - I've been trying to Upsize an Access2003 database to SQL Server Express. It transfers the structure fine, but no data. It's a very simple database I created for testing, but the Upsizing Wizard in Access fails everytime to tr....(more online)
Multi-Select Parameters for Reporting Services - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/ADavel/3138.asp....(more online)
A Replication Interview Book Review - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/awarren/3142.asp....(more online)
A Replication Interview Book Review - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/awarren/3141.asp....(more online)
A Replication Interview Book Review - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/awarren/3140.asp....(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)
A Replication Interview Book Review - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/awarren/3139.asp....(more online)
SQL Server 2005 Best Practices - Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/nKishore/sqlserver2005bestpractices.asp....(more online)
Katie's Raffle - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/pressrelease/3143.asp....(more online)
Exchange from SQL Server - Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/SBoriott....(more online)
Get And Set SQL Server 2005 Instance Registry Values - Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/vIacoboni/3092.asp....(more online)
Migrating Data Warehouse Systems to SQL Server 2005 - Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/vRainardi/migratingdatawarehousesystemstosqlserver2005.asp....(more online)
| 
