|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
SQL 2005 create new login error - please help
Huy Pham -
3 Dec 2005 11:35 PM - 3 messages
Hi everyone, I have a really peculiar problem with SQL 2005 Standard. It's installed on a brand-new, freshly installed XP Pro machine with VS 2005 Standard on it. There's no other services running. Problem: When I try to create a new login for some apps for VS with all the default ...
NTbackup VSS & SQL Server 2000
BCW -
3 Dec 2005 11:35 PM - 2 messages
As a newbie I have read that SQL 2000 is VSS aware, and so is the win2k3 ntbackup. Does that mean that the 2k3 ntbackup can do SQL server database and tran log backups (full, incremental, & differential) while the database ...
sql server 2005 express
Mohan -
3 Dec 2005 10:15 PM - 4 messages
Hi, I just installed sql server 2005 express on my computer. Is it possible to create a new database? I am not able to figure out how. All i c is some configuration tools. I would appreciate if anyone can help me out ...
sql 2005 restore db error
Jasman -
3 Dec 2005 9:06 PM - 2 messages
I am trying to restore a database from a bak file on disk and getting this error. Does anyone know what this means. The database 'test' is new and empty. It does not matter what the name of the database is. If I call it the ...
SOS, Urgent
Santu -
3 Dec 2005 8:55 PM - 2 messages
There is a file in my c:\winnt\system32 by the name sysfile.log, and it contains what seem to be the queries a reporting tool uses, and its filling up on disk space real fast, is anyone aware of this problem ...
Run a DTS Package "in the background" or with low priority?
John Bailo -
3 Dec 2005 8:19 PM - 2 messages
Configuration: Windows 2000 Sql Server 2000 Quad CPU Problem: I have a DTS update operation that takes many hours to run. The process is monthly, and for that process speed is not an issue; however, the database server hosts multiple databases, some with applications ...
Monitoring Cache
PP -
3 Dec 2005 8:00 PM - 2 messages
In most of the projects/companies these days, Disk space is not an issue, but many a times its the cache that hampers lot of performance. Even though people think they have enough disk space, they should not expect any ...
Why would i get this error ?
Hassan -
3 Dec 2005 7:57 PM - 2 messages
Error: 7105, Severity: 22, State: 6 Page (1:3938747), slot 74 for text, ntext, or image node does not exist. ...
Copy database to use for developement
AkAlan -
3 Dec 2005 7:31 PM - 2 messages
I have recently made the migration to SQL from Access. I have been using a database for the developement phase but now I need to copy the structure and use it for the final product. I want to leave the existing database to use ...
question about cached queries
Dodo Lurker -
3 Dec 2005 6:34 PM - 2 messages
Hi I am trying to understand SQL Server's internals and I was wondering how syscacheobjects works with memory. If an application sends a query to the database, does the execution plan stay in both memory and syscacheobjects or is syscacheobjects ...
Sample / Snapshot Database
christopher.colley -
3 Dec 2005 4:16 PM - 3 messages
Greetings, We have a 5gb SQL2000 database - and want to extract XX records (or XX percent of records) from each table so that the new DB will be about 150 mb can be copied onto a CD-ROM. We will use the resulting DB for ...
SQL Server 2005 mirroring problems
Asaf -
3 Dec 2005 1:26 PM - 8 messages
Hello, I am facing with two problems with SQL Server 2005 mirroring: When first trying to make a mirror there is a need to add trace flag –t1400 as there is messages that currently mirroring is only for evaluation. ...
upgrade from SQL2000 to 2005
SF -
3 Dec 2005 2:07 AM - 3 messages
Hi, I just want to know if there is any issue while upgrading from SQL2000 to 2005 SF ...
I'm not a SQL programmer but I need help please in sqlserver
Tim -
3 Dec 2005 12:23 AM - 3 messages
Hello Yes, I certainly am not a programmer. Access gives me enough of a headache. What I'm after is some advice. Me and my brother run a small business and we have decided to have a database developed specifically for our business. The question is what do we ...
Not Able to Edit SQL Data in Access
wenzlow9 -
2 Dec 2005 10:50 PM - 6 messages
Greetings. I am using SQL Server 2000 to store my data, Access XP 2002 SP-3 for the front-end, and MDAC 2.8 RTM. I cannot edit any of the data in the SQL tables from Access. I can enter new data, but once it ...
MS SQL 2005 Management Studio
Steve Z -
2 Dec 2005 10:42 PM - 5 messages
Where do I find the Management Studio to install on my laptop? I've just installed MS SQL 2005 on a SBS 2003 machine in the office, and it says I cannot use regular old EM to register the server on my laptop. ...
running stored procedures from SQL Agent
Gary -
2 Dec 2005 9:23 PM - 13 messages
I'm trying to understand some behavior I'm seeing running a stored procedure as a TSQL jobstep in a SQL Agent job. If I run the sp from query analyzer or osql, it completes as expected, but in the process may generate a few 3604 ...
Wide Composite or Separate Indexes on FKs?
ScottL -
2 Dec 2005 9:03 PM - 2 messages
I have a details table in a relatively normalized schema. It consists of an Identity column, 8 FK columns (smallint/int), 1 Posix date/time column (int) and 7 data columns (all int or bigint). Total record width is 82 bytes. This ...
How to run SQL Server Management Studio
Matt -
2 Dec 2005 8:56 PM - 5 messages
We have installed SQL Server 2005 on a machine running Windows 2003. We found out that there is no Enterprise Manager, but Management Studio. We have no idea how to run this. We tried to remove SQL Server, but Add/Remove doesn't remove it. Just only ...
Indexes
Joe K. -
2 Dec 2005 8:45 PM - 6 messages
I have cluster index created on a composite primary key (acct_key,period). I would like to create a non-cluster index on the acct_key field, since there are numerous sql statements that extract single value from this field. Please let me know if cluster index has a composite primary key neither ...
Positive/Negative with ROWLOCK
Joe K. -
2 Dec 2005 7:52 PM - 2 messages
When you want to use a ROWLOCK? When you not want to user a ROWLOCK? Thank You, ...
Help; ASP web site, IIS 6.0, Server 2003, SQL server 2000
ARMS -
2 Dec 2005 7:43 PM - 3 messages
Hi I,m new to Server 2003 and I'm moving an ASP website to it. This is what I have; an basic ASP web site that connects to a "SQL server 2000" database on Windows XP box, using IIS. ...
problem logging onto Great Plains.
David Goldberg -
2 Dec 2005 7:09 PM - 8 messages
I have a user who is trying to log into Great Plains. It uses SQL Server 2000 which is on the same server. HE gets the following error message: "Error occurred creating the pass-through SQL connection.:0" ...
Moving backup devices
TheOne -
2 Dec 2005 6:54 PM - 2 messages
Is there a way to copy backup devices between 2 servers with a script or something else ? I actually need to move my current installation on a new server and I don't want to recreate 200 backup devices manually. ...
Row Lock On Update Statement
Joe K. -
2 Dec 2005 6:47 PM - 3 messages
What is the correct syntax to create a row lock for an update statement that updates only a single row in a table? This should help performance since it does not have to lock the table to update a single row. ...
edit a DTS package in sql 2005?
mp3nomad -
2 Dec 2005 6:31 PM - 4 messages
How do you edit a DTS package that has been migrated to SQL 2005 from SQL 2000? I can see the DTS package by connecting to SSIS on the SQL 2005 box but can't quite figure out how to edit it. ...
How do I find Total Disk Size from SQLServer
yodarules -
2 Dec 2005 6:30 PM - 5 messages
I know you can use xp_fixeddrives to find the free space left in the disks on the sql server box. I trying to write a procedure where I can set a threshold in the DB for each disks and once we reach it send me an email. Now I have the Disk Size as ...
Restoring a database to the same server but with a new database na
Quang Nguyen -
2 Dec 2005 6:09 PM - 6 messages
Hello, I need to restore a database from a disk backup to the same server. However, I need to restore it using a different name because the original database is still in place. I have database1 which is the original db. I've ...
Stopping and restarting sqlserver service, it can not rebind the 1433 port, server reset needed...
SammyBar -
2 Dec 2005 6:03 PM - 3 messages
Hi all, It is second time I face the same problem: When restarting the sqlserver service, it can't bind to 1433 port. Looking around which process is binded to this port, it results the System process is! It is neccesary to restart the server in order to the sqlserver ...
Database mail issue - any ideas?
Corey Bunch -
2 Dec 2005 6:00 PM - 6 messages
We recently installed 2005 and have been playing with it. I seem to be having a problem with Database Mail as it relates to job notifications, and wanted to see if anyone knew what I was doing wrong or how to fix ...
Maintenance Plan Issues 2005
Sameer Raval -
2 Dec 2005 5:48 PM - 3 messages
Maintenance Plan When I tried to create Maintenance Plan [MP] for full DB Backup and Hourly transaction log, I was not able to do that in one plan. I have tried both design and wizard option. The reason for that is in 2005 it will not allow you to have 2 schedules ...
Creating Database file greater than 2 TB.
ray -
2 Dec 2005 5:47 PM - 4 messages
Hi, I need a database file greater than 2 TB. The disk size is 2.5 TB. But SQL 2005 is not letting me create a file greater than 2,097,152 MB. Is there a way to increase the size of it. ...
SQL question
langjr15@uwgb.edu -
2 Dec 2005 5:17 PM - 2 messages
Hey guys I have a vb.net application thats supposed to take things from a form and update it to a table. The item in particular I am having problems with is a textBox with a date in it. I use the date dialog ...
Process constantly polling the tmw_queue table looking for work to do
confused -
2 Dec 2005 5:13 PM - 2 messages
I have created a package that will backup prod. database and restore dev. database. The job failed because there is a process constantly polling for work to do. How can I have the job kill this process, put database in single user ...
cannot delete with DELETE permission?
bing -
2 Dec 2005 5:10 PM - 11 messages
Hello, One of our users said he was not able to delete records in a table. When I looked, he did not have DELETE on that table. Then I checked DELETE for his account. But he still cannot delete any records. I don't think there is ...
Groups Database Accesses
Raymond Barrett -
2 Dec 2005 5:05 PM - 2 messages
I have a sql 2000 server. There are several databases in it. In one database the database and columns accesses don't work for windows groups. They only work for individual users, but not so in all other databases. Even ...
What Version of SQL on x64 Ent?
Shawn -
2 Dec 2005 4:38 PM - 3 messages
What version of SQL should we install on 2003 x64 Enterprise? We've been up and running with the normal 32 bit version since August, but now we have a SQL "guru" telling us that we need to use the 64-bit version, which I thought ...
Question Regarding Execution of Stored Procedure on linked server using RPC
Ed -
2 Dec 2005 4:00 PM - 2 messages
When I execute a stored procedure it always works fine using the syntax EXEC server.db.catalog.stored_proc_name However whenever I change the stored procedure to have parameters and attempt to pass the parameters to the stored procedure I receive the ...
GROUP BY
Roy Gourgi -
2 Dec 2005 3:34 PM - 3 messages
Hi, I am using C# and SQL 2005 Express and I would like to know if there is a way to group rows by some columns in such a way that I can clearly see them in a distinguished fashion when I look at a view or table. ...
why not use port 1433?
ChrisR -
2 Dec 2005 3:15 PM - 2 messages
I've always assigned SQL to something other than port 1433. But it suddenly donned on me, there are probably virus' and/or worms out there that try to figure out what port SQL is running on and dont just assume its 1433? ...
Maintenance Plan Recreates Deleted Table?
n_o_s_p_a__m -
2 Dec 2005 3:10 PM - 4 messages
Hello All, I created a table, imported from Access. It has a wierd name: 'TableName$'. Every day I delete it, and each night, it gets restored. It just won't go away. This doesn't happen with any other tables. ...
DTC problem with SQL 2005 on Server 2003
GilaMonster -
2 Dec 2005 10:51 AM - 4 messages
I'm getting a strange error trying to run a distributed transaction between 2 SQL 2005 machines. The error reads 'OLE DB provider "SQLNCLI" for linked server "RemoteServer" returned message "No transaction is active"' 'Msg 7391, Level 16, State 2, Line 2' ...
Return all rows works partially
Peter CCH -
2 Dec 2005 9:44 AM - 5 messages
I encounter a problem where returning all rows from a certain table in SQL server 2000, the records sometimes can be return sometimes not. In Enterprise Manager, I browse to a table, then I right click on it, click "Open table > Return all rows" ... it just keep waiting until it ...
Default File path in 2005
dishan -
2 Dec 2005 6:36 AM - 2 messages
Hi How do I get default file path using TSQL/SP in 2005?? In MSSQL2000, I used sp_MSget_setup_paths undocumented sp to get this information. Please help Dishan ...
SMB2003 vs SQL 6.5
Ivan -
2 Dec 2005 6:27 AM - 4 messages
We know that SMB2003 comes with SQL2000. However, our application is still using SQL 6.5 Is there any problem if we install SQL 6.5 in SMB 2003? besides, is there any license conflict? Best Regards, Ivan ...
newbie: fix a bad security setup
usenetjb -
2 Dec 2005 4:36 AM - 2 messages
we have some sql server 2000 2p3 instances running on win2k. Small company and long ago the original developer set up the server with an superuser/admin account. all apps and all developers access these servers with that one account. (yes i know...). ...
DBCC INDEXDEFRAG
smounkhaty -
2 Dec 2005 4:07 AM - 2 messages
Hi Guru, One of my vendor database has about 500 tables where owner not belong to dbo. I'm having a hard time to do online defrag from M-F because my code is not working. Please look at my code and modify it when owner ...
Norton Antivirus / SQL Server
Dan -
2 Dec 2005 1:12 AM - 2 messages
I have a Windows 2003 Server STD box with SQL Server 2000 STD on it. I want to install Norton Antivirus Corporate. Are there any Norton/SQL issues that I need to be aware of? (ie. folders to exclude, performance issues). ...
Converting calculated field to real
Randall Arnold -
1 Dec 2005 11:50 PM - 3 messages
I have a view with 3 integer fields: FailureCount, QuestionCount and AuditCount. I want to get the following calculated result in a SELECT statement: SELECT FailureCount / (QuestionCount * AuditCount) Problem is, this returns an integer result (as one would expect from 3 ...
SQL Server 2005 Express Merge Module
Yosh -
1 Dec 2005 11:15 PM - 2 messages
Does anyone know if there is a SQL Server 2005 Express Merge Module available? We want to be able to install SQL Server 2005 Express as part of installation setup. Any ideas or suggestions would be appreciated. Thanks, Yosh ...
What is the difference between the runtime vs the full SQL server
Gigabyte -
1 Dec 2005 9:04 PM - 2 messages
I'm trying to find what the difference is between SQL runtime vs the SQL server (SQL 2000)? In particular, I'm curious if I have ten or so users working with an application that uses SQL runtime what benefit I would get installing ...
SQL Server Agent Alerts
LaEsmeralda -
1 Dec 2005 7:20 PM - 2 messages
How do I set up SQL Server Agent to alert me on cell phone? Thanks. LaEsmeralda ...
Performance concerns with Image column along side simple type columns
msSqlServerNewbie -
1 Dec 2005 7:08 PM - 2 messages
I am using image types to store files in sql server. I know this can be quite wasteful; but in my application flexibility is key. The format of the input (To be stored in my image field) is likely to often ...
Can't start a job that was created by user A from user B
Johnny -
1 Dec 2005 6:55 PM - 3 messages
Hello all, I have a job I created with user A, but I need user B to be able to execute this job programatically. I've given user B permission to EXECUTE the "msdb.dbo.sp_start_job" sproc and the user is able to execute it but with an ...
SP4 upgrade
Chinna Kondaveeti -
1 Dec 2005 6:41 PM - 2 messages
SQL Server with SP4, Win 2003 Server. We have upgraded our SQL SP3 to SP4 only last night. The SQL Service is taking 90 to 100% most of the times after this upgrade. The client connections are getting slowdown and timeouts. ...
Network Backups SQL server 2005 Ent
Unreal400 -
1 Dec 2005 5:40 PM - 2 messages
I am trying to backup to a network drive. When I choose backup to disk it will not show anything but my local drives. I put in a UNC or a mapped drive and it says it cannot validate the existance of the backup directory. ...
Table field limit
Craig -
1 Dec 2005 5:31 PM - 4 messages
General question: How many fields/columns can a SQL table accomodate? I have a text file that has 490 fields - probably will make sense to break it up, but I was just curious. Thanks. ...
Limiting data in Indexed Views by date
marketing -
1 Dec 2005 5:25 PM - 2 messages
Hi everyone, We have a fact table containing 28,000,000 rows and are experiencing scalability issues when performing queries. It turns out that indexed views are an excellent way to pre-calculate aggregates and improve scalability. The problem is that the table is part of an OLTP solution, and is ...
Copying data across rows
nicole -
1 Dec 2005 4:12 PM - 4 messages
I have one table where I am trying to copy a number from one field in one row into another field in another row based on two conditions. More specifically, I need to copy the number from column DIFF for ...
SqlServer 2005 low performance
erdem -
1 Dec 2005 3:44 PM - 2 messages
hi all, i need to take advice about sql server performance. We are using SQL Server with Commerce Server 2002. We have upgraded our SQL SERVER 2000 to SQL SERVER 2005. Our CPU usage was between 40%-70% when we ...
Change collation for an existing database
Vincent D. -
1 Dec 2005 3:38 PM - 3 messages
Hi ! I would like to know how to change the collation of an imported database. I tried something with DTS, but I'm quiet a beginner with this tool. So if anyone could help me on this one, this would be great ! ;-) ...
SQL2005 on W2K3 R2
Chris Wood -
1 Dec 2005 2:46 PM - 2 messages
Hi, Looks like we may be installing SQL2005 Standard on a W2K3 R2 box with 7.5Gb of ram. I know that W2K3 R2 has not been RTM'd yet but is anyone using the RC1 with SQL2005 and having anything to report? ...
SQL 2005 vs 2000 question...
Chris Marsh -
1 Dec 2005 2:28 PM - 5 messages
I have two primary questions that I hope someone can shed some light on - First, I have installed 2005 and see only a few issues when I run the upgrade advisor tool. The problem is that they don't really jump out as ...
Regarding BulkInsert
msqldba m via SQLMonster.com -
1 Dec 2005 1:47 PM - 2 messages
Hello, I am trying to do this and i am getting this error.. create table #temptbl (rec varchar(284)) BULK INSERT #temptbl FROM 'z:\Testline.txt' WITH ( DATAFILETYPE = 'char', FIELDTERMINATOR = '\r\n', ...
SQL Deadlocking
James -
1 Dec 2005 1:13 PM - 3 messages
Hi I am wondering is someone can advise: We use Microsoft Dynamics which sits on SQL. We are now getting a fair bit a SQL deadlocking and I have been banging my head against a brick wall with this. ...
Importing databases in SQL 2005
The Vogon -
1 Dec 2005 1:05 PM - 3 messages
I'm having a lot of trouble importing/moving databases between SQL2005 servers. -If i detach/copy files/attach, I get user security problems (ie. user defined in database "does not exist" on new server, but cannot be removed from database as owns schemas etc.) ...
Configuring SQL Server Express 2005 for Remote Access
NoSpam -
1 Dec 2005 11:15 AM - 3 messages
Hello All In the course of another thread I posted a question regarding problems connecting to SQL Server Express 2005. The fundamental issue is that SQL Server Express does not have remote access enabled by default. Enabling it is a multi-step process. ...
Set mixed mode
refdk -
1 Dec 2005 10:35 AM - 3 messages
Hi We are using the Enterprise Manager to make corrections in several MSDE databases used by a web client application. First we attach the database in SQL, make the corrections and then detach. Before we are able to access the database from the web client again, we ...
Copying SQL 6.5 Database to SQL 2000
Gav -
1 Dec 2005 10:08 AM - 2 messages
What is the easiest way to copy a 6.5 database to a SQL 2000 server? I've tried to backup and restore with NetVault but it does not seem to work, thought I'd done this in the past with Backup Exec but might be wrong. Is ...
ORDER BY - clause
SouRa -
1 Dec 2005 9:04 AM - 5 messages
Hi, I have the following output from a SELECTion query. Query: SELECT RollNo FROM Student Output: 10 20 30 40 I want this result in following oder 20 40 10 30 Is it possible? please advise me. Thanks, Soura. ...
Unclustered index faster than clustered index?
Leslie -
1 Dec 2005 7:41 AM - 6 messages
Hi. I have a table with 338859 records. The table has a userid column of type varchar(20) (null enabled). I use the following query: select * from table1 where userid = 'X' with X being a random userid. This is a slow test computer with 512 Mb ram ...
SQL replication data in publication
maxzsim via SQLMonster.com -
1 Dec 2005 5:36 AM - 3 messages
Hi, I have set up a txn replication, where is the data stored ? in the Publication database ? how can i actually view the data in the publication db or it's stored as binary format ? appreciate ur advice tks & rdgs ...
Restore Database
Mark -
1 Dec 2005 4:08 AM - 4 messages
If I would like to create a training database (abctest) by restoring the production database (abcprod), I would like to know 1) Is it necessary for me to create abctest first OR just restore the backup of abcprod and the training database will be created automatically ? ...
What SQL Server 2000's issuses are solved/remain in SQL Server 200
zx -
1 Dec 2005 4:03 AM - 2 messages
What SQL Server 2000's issuses are solved in SQL Server 2005? What SQL Server 2000's issuses are remain in SQL Server 2005? Is there a bug fix list for SQL Server 2005? Similar to SQL Server SP1/2/3/4... ...
One report of SQL2005 running fast!
jxstern -
30 Nov 2005 11:39 PM - 4 messages
Just a good news post, that there's at least one report here that a trial installation of SQL2005 is running one big, fat, slow SP something like 20x faster. This is a big, complex SP (if I have the name right!) and in SQL2K it ...
xp_smtp_sendmail
prem -
30 Nov 2005 11:33 PM - 2 messages
hi all, I'm trying to implement mail sending, using the xp_smtp_sendmail proc. pinging my smtp server works just fine. and when sending a mail the proc returns code 0. (success) but, somehow, the massage doesn't arrive to the mail box. ...
Bring up the standby server in sql 2k
mecn -
30 Nov 2005 11:13 PM - 6 messages
Hi, How do I bring up the standby server online in sql2k by restoring the last log backup(backed up with noinit). This log file has been restored with standby clause. can I restore again with recovery? Thanks, ...
Transaction Log Backups
Elecia -
30 Nov 2005 10:45 PM - 3 messages
Hi All, Can anyone tell me whether backing up the transaction logs for the master database is the equivalent of backing up the transaction logs for all the db's on that server or is it strictly backing up the transactions for the ...
Sql Query
Mel Weaver -
30 Nov 2005 10:44 PM - 3 messages
Hello, I have a vehicle database 100,000 records with Year, Make, Model, Body,Vin, SRP text fields. What I would like to do, is delete duplicates records with the lowest SRP field, example below. Looking for any ...
DTS disaster recovery
Terri -
30 Nov 2005 10:16 PM - 3 messages
Can anyone recommend any best practices for restoring local packages? In a disaster recovery situation I will have 1 SQL Server box rather than 4 so I won't be able to restore all of my local packages by restoring MSDB. Any ...
SELECT permission denied on table
Randall Arnold -
30 Nov 2005 9:45 PM - 4 messages
I created a simple table in a SQL Server 2000 database under the dbo account. When I log in under a different account (developer) I cannot see this table. If I try running a query that refers to the table, I get the ...
Upgrading 2000 Standard Edition to 2005 Trial Edition
jhale -
30 Nov 2005 9:16 PM - 3 messages
It will not let me do the upgrade. I receive the following message: Name: Microsoft SQL Server 2000 Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL ...
SQL Server 2005 and Analysis Services
olli_d -
30 Nov 2005 9:16 PM - 2 messages
I have installed the SQL Server 2005. I can create a new Database. but i cant create a new cube in analysis service. how can i connect to my created Database ???? ...
SQL Server 2005 Enterprise Edition Installation Issues
Yared -
30 Nov 2005 7:17 PM - 3 messages
I have SQL Server 2005 Enterprise Edition; I don't see the following components: 1. Database Services, 2. Analysis Services, 3. Reporting Services, 4. Notification Services, 5. Integration Services ...
SQL Server Query help
dilip.movva -
30 Nov 2005 6:58 PM - 3 messages
Hi, I have a Student table and course table. Every student will enroll in 3 courses. The strucutre of the table is Student ----------- Studentid, Student Name, Course1ID, Course2ID, Course3ID I have the course table Course ...
Profiler problem
Frank Rizzo -
30 Nov 2005 6:28 PM - 2 messages
If I try to filter the SQL Profiler data by Database name, it has no effect. Is this a known bug or am I doing something wrong? If I limit it by Database ID, it does work. In addition, if I add the Database ...
Rename virtual server
TheOne -
30 Nov 2005 5:01 PM - 2 messages
Hi, Is this possible to rename the virtual server in a cluster environnement ? I use SQL2000 with win2003 server. ...
automatic dbase backup fails
Paul -
30 Nov 2005 4:50 PM - 5 messages
Hi just wondering if anyone has any ideas what would cause an automatic backup to fail when the manual backup works fine? There seems to be plenty of disk space. Also there does not to be a log created showing any error ...
How to implement a data base design for multi language support?
Dirk -
30 Nov 2005 4:40 PM - 3 messages
Hi, I have searched the web for several hours now to find a reference solution based on the available features of Sql Server 2005 to implement a data base with multi language support. I would like to create a database that is able to store multiple ...
SP4 upgrade ?
Alex Anderson -
30 Nov 2005 4:25 PM - 3 messages
Hello Everyone, I'm in the process of upgrading my SQL 2000 from SP3 to SP4. I've read Microsoft's technical versions of their Readme's, however can someone provide me with a link to a better resource when applying SP4 to their SQL ...
log shipping sql 2005 database remains in (restoring...) mode
Dlorbecki -
30 Nov 2005 4:21 PM - 3 messages
I've been playing with the SQL 2005 log shipping and have been running into a few problems. My system is configured on a virtual server with two instances of SQL 2005. The OS is Windows 2003. I'm shipping logs from the default instance to the ...
audit tool
hongo32 -
30 Nov 2005 4:03 PM - 11 messages
hello, i listen that exists many tools for register all the changes made to the tables, for audit purpouses, can somebody recommend to me what options exists... ? exists free option? ...
debug a stored procedure in SQL Server 2005
Jaime Lucci -
30 Nov 2005 3:43 PM - 7 messages
Hi everyone! How can I do to debug a Stored Procedure in SQL Server 2005 from SQL Server Management Studio? I looked for the Debug... option when I right-clicked the SP but it seems that in SQL Sever 2005 doesn't not exist. ...
migration from Beta 2 to Final edition
John -
30 Nov 2005 3:41 PM - 2 messages
Will you please let me know how to have a smooth and NO DOWNTIME migration from Beta 2 to Final version of SQL 2005? As per Microsoft, SQL 2005 final version does not upgrade itself from Beta 2. Thanks John ...
problem creating DTS package
Mohan -
30 Nov 2005 3:39 PM - 9 messages
Hi, I am trying to create a DTS package wherein the data from the sql server is transfered to a text file. I am using the Transform Data Task to transfer the data.In Transform Data task properties, I build the ...
Problems accessing data from recordset (SQL Server 2000)
CrazyAtlantaGuy -
30 Nov 2005 3:27 PM - 3 messages
I'm having a strange problem and I was hoping someone could give me some guidance. I am accessing a Microsoft SQL 2000 server through ASP scripts on our webserver. The sql server and web server are on the ...
Connecting to Reporting Services Server Fails
Simon Worth -
30 Nov 2005 2:51 PM - 2 messages
Originally posted on Reporting Services newsgroup - Then on Setup - no answer there though, so I thought I'd try the Server group as well. I've looked through documentation and can't find an answer there, and nothing on the web that seemed to apply either. I'm hoping someone can ...
Log Shipping with additional backups
si -
30 Nov 2005 12:15 PM - 2 messages
I am planning to implement log shipping between two servers. I understand that if I perform a full database backup of the primary database during the log shipping, this will have no effect on the log shipping. If I am log shipping every 30 minutes, so I have a log backup at ...
Intel Hyper Threading
James -
30 Nov 2005 12:09 PM - 6 messages
Hi Has anyone had any SQL performance issues when Hyper Threading is enabled on BIOS? Do you have any comments regarding to HT? I know this is a bit of a grey area for Citrix - but i have not seen any ...
sysprocesses.memusage are the pages 8K?
Paul Cahill -
30 Nov 2005 10:59 AM - 4 messages
I have found that we have a old VB programme executing raw sql that is using over 95% of our procedure cache (using sysprocesses.memusage). All our other apps use stored procs. However I wanted to understand this figure better. BOL describes ...
|
|||||||||||||||||||||||