Very basic question. OS Windows XP pro On bootup, an application that starts automatically in the start-up folder, starts before SQL server is running This only happens on slower hardware, It must be a common problem, what's the usual solution? -- Graham. %Profound_observation% ...more >>

I would like to re-use the CASE expression without having it written twice but trying to use "feeder" in the WHERE clause fails: SELECT feeder = CASE WHEN rtrim(system_feeder_id) = 'CORE' THEN 'CORE' ELSE 'ODS' END, FROM tbl WHERE CASE WHEN rtrim(system_feeder_id) = 'C...more >>

I need to write a stored procedure that polls a database every 10 seconds to gather data and insert it into a table in another database. It needs a retention span of one week, then will delete the oldest data prior to inserting the new data. I have a working SQL to gather the data but am h...more >>

SELECT isnull(cval, 1) cval FROM tbl I dont understand what isnull(cval, 1) cval does exactly. Any help is appreciated. ...more >>

Dear all, Suppose that I have a table contain the following columns. create table prodstate (productid int, stateid int, year int, salesamt float) I will be doing the following query Select * from prodstate where year=2007 and stateid = 2; My Questions is: 1) Should I have a comp...more >>

I pretty much think I know what this does, but I've never seen a DELETE statement with 2 FROM clauses: delete from #acc from ggg d where #acc.id=d.nbr and d.oid='294' I think this is the same as DELETE FROM #acc WHERE #acc.id IN (SELECT nbr FROM ggg d WHER...more >>

ok, I have a table with names of countries. I have another table with a description field. I want to join the country_name with the description field, BUT instead of the join being based on equality, I want it be based on country_name appearing in the description field. Is this possible? ...more >>

Hi, i've installed SQL Server 2005 Standard SP2 on a W.2003 Std. SP2, and I'm worried about the security. Server authentication is "SQL SERVER mixed mode", and windows firewall is on, but 1433 tcp port is open beacuse the users needs to manage their databases remotely. Databases are created t...more >>

I think my Database is refering to the wrong time somewhere. If I run SELECT GETUTCDATE I get the wrong time if I run SELECT GETDATE this shows the right time. It looks like it's using GETUTCDATE can I force it to use GETDATE? The actual Windows Server is correct as well. ...more >>

Hi, I've been scraching my head on this for so long. We have two servers (both running SQL 2005 64-bit Enterprise Edn SP2 on Windows 2003 Standard 64-bit), one of the servers is able to send the attachment in the email, whereas the other is failing with Msg 22051 error: Msg 22051, Level ...more >>

I am using MS SQL 2005 and the stddev function to some sets of records. It appears as though the sql server only needs 2 values to produce a STD Deviation. Obviously this value isn't of very much use at all, but it is weird that it calculates it at all, most std dev functions need at least thr...more >>

I am trying to optimize a stored procedure. One thing confused me is that on the SQL Profile trace, the version with more cpu, read, and write has less duration. Usually I see duration is almost directory linked to cpu time. Does anyone know what could cause this? Thanks. Lijun ...more >>

When I run select @@servername where does the servername come from? It isn't the master.sysservers table like I thought. Thanks Bill ...more >>

I have inherited a SQL Server (2005) from an outgoing DBA and while I'm familiar with databases from a data structure/manipulation standpoint, the permissions/security model in SQL Server 2005 has baffled me thus far. I digress... There's a schema called dbo and every object is prefixed as:...more >>

Hello. In Sql Server 2005, the way deadlocks are reported has changed. I get the following info (below). What do numbers following the KEY mean? KEY: 19:72057600982122496. I suspect that 19 is the database ID, but I can't figure out what 72057600982122496 refers to. I am trying to g...more >>

I have a select statement that goes against a view. When I run it on my SQL 2000 database it takes 18 seconds, but when I run the same query against the same database in SQL 2005 it takes over 18 minutes to return the same records. What can I look for to find out why its taken so long on my SQ...more >>

Can someone explain the option "backup set will expire" to me? I figured this would be the option to set how many backups I want to keep. I set it to "After 1 day", yet I have 4 days worth of backups in my backup directory. Did I set the wrong option? I only want 1 backup. Thanks, Andre ...more >>

We have one production SQL server that houses 2 databases - a production database and a demo database. We want to take the backup of the production database from last night and restore it into the new demo database running on the same server. We are having some issues with not being able to ...more >>

Hi. I am struggling to link a SQL2005 box to a SQL2000 box via linked server. I have done this before and am replicating what I did then but I can`t get it to connect. However when I connect via query analyser using the same credentials it connects with no issues. Has anyone seen this before ?...more >>

SQL BOL says that the @terminate parameter for sp_change_primary_role defaults to 0 while it defaults to 1 in sp_change_secondary_role. In both cases, this param "Specifies that all pending transactions be immediately rolled back" and puts the db in single user mode while the stored proc runs....more >>

How do I turn on IDENTITY_INSERT for a table in SQL 2005? -- Regards, Fred Chateau fchateauAtComcastDotNet ...more >>

Dear all My server received following information around 2 months from event viewer. Error: 17883, Severity: 1, State: 0 The Scheduler 3 appears to be hung. SPID 0, ECID 0, UMS Context 0x00CDA950 (We have not a scheduler 3 in my sql) After that, i disable symantec antivirus on my server, ...more >>

Hello, I'm hoping someone here can give me some advice on the best way to configure my situation. We're running SQL Ent on Win2KA with 6GB RAM. We have both /PAE and /3GB enabled, and SQL set to a max server memory of 2GB. However, when I look at performance counters from the SQL Buffe...more >>

SQLServer 2K all packs SQLAgent won't start - the service is using all defaults,System Account etc (although Itried using a domain account as well - still fails) The error it is generating is below - thanks! [298] SQLServer Error: 229, EXECUTE permission denied on object 'sp_sqlagent_...more >>

Hi all, I'm running sql 2005 sp1 on 64bit server. Enabled Database Mail in SSSAC Configured Database mail via Wizard. Sent a test mail (with success) Enabled mail profile under Alert System in SQL Server Agent Properties Restarted SQL Server Agent Now I'm opening my new job I made. -> P...more >>

My SQL 2000 server seems to be logging data an hour early, the Windows 2003 time is correct though. What steps should I take to find out what is happening. I'm in the UK and we have to change our clocks for day light, but these are all set to automatically adjust clocks. Should it be usin...more >>

Hi, I got this error when I move the log file to a diff location in the cluster environment. Any ideas and solution? Thanks Msg 5184, Level 16, State 2, Line 1 Cannot use file 'T:\Logs\myrpdLog.ldf' for clustered server. Only formatted files on which the cluster resource o...more >>

To avoid having to pass this user specific ID via a parameter in the stored procedure, is it possible to create your own function like (like suser_sid()) or variable (like @@SPID) ? This value would be passed from a Web Service (asp.net 2.0) in the connection string or something and could be r...more >>

I was setting up a new SQL 2005 sp2 (x64) box and restoring dbs. I restored DB1, then moved on to DB2. I was restoring from a file, so I added the file, forgot to change the db name in the dropdown, so it still said DB1, changed the file paths, and clicked ok. So of course when I clicked ok...more >>

We have SQL 2005. Say our SQL servers are in Domain 'ABC' and our clients are in Domain 'XYZ' where the domains dont trust one another. Theres more details but in short,I want to add Windows accounts i.e. (XYZ\User1,XYZ\User2,etc.) without being authenticated against the domain controlle...more >>

I am creating an SP. I want to compare alternative ways of writing the query to see which one is the most efficient. I am trying to use the execution plan but it doesn't give an overall cost of the query so I can compare it to the alternative query. Rather I get a break down of the various ste...more >>

I am working to see if we have memory pressure. We are on SQL Server 2000 with compatabiity level set to 70 Windows 2000 4 gigs memory. When I run the SQL Server Target Memory and Total Server Memory they both come up with approx 1.6 gigs. My questions are, we set memory dynamically and expect...more >>

A user called ZoomZoom made the posting below on Tech Republic. As it did not get a reply there I am interested to know what the community's opinion is. Some of my Raid 10's are made up of 8 drives. Would it have been better to have created 2 Raid 10's of 4 drives and then have two data files...more >>

Some days ago I created a view on a sqlserver database, that returns the price and some other infos of invoice items. everything worked fine. Now, the view didn't return the same as when I created it. The price column of the returned record set showed the invoice date instead of the price a...more >>

I have run into an issue that if I use the parameters passed into strored procedure directly the performance is slower than when i declare local variable and assign the values passed in the procedure to those local variable and then use the local variables. Why is this the case? Rahul ...more >>

I have stored procedure that is taking longer time in production than in Test. I narrowed the longer time being taken to the order by clause in a subquery. The execution plans look different in the test than in production server. The databases are identical. What could be causing this? The ...more >>

I am having trouble connecting to SQL Server 2005 from my home via VPN connection to my office. I have enabled remote connections on the server. I can actually connect to my local SQL Server instance from the Server machine while connected to the VPN but not the other way around. I can browse...more >>

Hi Folks, Any easy way for me to analyze the number of inserts, updates, selects and deletes on each table in the system? When most of the work heppens via the SP? Note I am not database owner, I can't make structure, trigger, scripting changes. I can monitor it using SQL Profiler, or...more >>

I'm using SQL Server for the first time for a web site back-end and I'm having problems with numbers. I have a field that accepts numbers (the data type is float). When a user submits a value like 159,000 it causes an error. When they enter 159000 it does not. Is this normal? Thanks. Br...more >>

In SQL 2005 I have a server with a username of JM. This username created and maintains a database. When I login via query analyser I can`t run queries on a table unless I qualify it JM.tablename. How do I alter the login to ensure i can query just on tablename ? Simon...more >>

Hello, I'll try my luck in this group before I re-install the whole thing. I'm running MS SQL Server 2005 developer edition on the Windows Server 2003 Small Business Edition. Few days ago I have updated to the SP2 via windows update. Since then I cannot connect to the SQL server remotely ...more >>

We are experiencing an odd performance issue with SQL Server 2000 SP3a and remote queries to an IBM AS/400 when they are in a store procedure call from another stored procedure. I have included some simple examples below. Incidentally, this problem has only recently developed. If I call the...more >>

Hi All With SQL Server 2005 what is the best way to be alerted when autogrowth on a file occurs? Thanks...more >>

...more >>

We have couple of SQL databases on different SQL Servers that are at different remote locations in two different network domains. The requirement is to generate reports by pulling in information from both these databases. What is the best way to go about it? We have been asked to consider ...more >>

I have a SQL server 2000 server with two instances running. One the default, one named. I tried to upgrade the server to SP4, and I was prompted to choose which instance to upgrade. I chose the default. SP4 refused to upgrade the default instance with this message: "MSSQLSERVER ...more >>

Hi All, I want to log all activities happening in SQL server. I already know some auditing tools do it like: 1- DB Audit 2- ApexSQL Also I activated SQL server audit log and all of them are helpful but, the problem is they couldn't capture table fields that users see (not update/delete/add...more >>

hi, the virtual sql servers are sharing the same windwos RAM memory, utilize processor(s) and Disk IO? What's is the diff between creating virtual sql servers and adding more sql instances in one sql server? 1. each Virtual server need sql and windows licenses. sql instanses no need addit...more >>

Hi, If I add an sql 2000 instance to a existing prod sql box used as a developping sql instance. The developers don't need to tough the production box.. Is it feasible? it will reduce the production performance? What's the side effect? What about creating a virtual server --- 2-3 virtual ...more >>

And one other Q, is there any way to get the number of reads/writes, one each table, for a particular time period, without profiling the db? Thanks again! ...more >>