|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Should the parent disk of a differencing disk be sysprep'd?
Spin -
6 May 2006 9:11 PM - 2 messages
Gurus, One more question about differencing disks. Should the parent disk of a differencing disk be sysprep'd? ...
can I update based on a join result with a calculation
Mike -
6 May 2006 7:57 PM - 3 messages
My table design is CREATE TABLE [HashKeyTotals] ( [hKey] [bigint] NOT NULL , [Total] [int] NULL , CONSTRAINT [HashKeyTotals] PRIMARY KEY CLUSTERED ( [hKey] ) ON [PRIMARY] ) ON [PRIMARY] GO and I also have data files of the same structure. My goal is to import the ...
SQl Server 2000 Service Pack 4
lbeham -
6 May 2006 5:22 PM - 4 messages
Hi, - Urgent request - need to fix right away: I completed the upgrade to SP4 however. I ran the select statements listed in the article above both before and after the upgrade. It still says SP3 both before and after however when I go to the software programs installed ...
Synchronize two databases - Migration
sales -
6 May 2006 4:53 PM - 3 messages
Hope I can get a game plan for this issue I am having. I am migrating our SQL server from a shared hosted server to a dedicated box. The database is over 1GB. I had the hosting provider make a backup of my database and give me access to the file (I cannot ...
How to create a new SQL account that just has rights to a specific database?
Spin -
6 May 2006 2:32 PM - 7 messages
Gurus, You know how in SQL Enterprise Manager you click on Databases node and see all the databases? And that the SA account has full access to all of these? Well, if, from here on out, I wanted to create a database that beside the SA ...
Right Alignment in SQL
SouRa -
6 May 2006 7:51 AM - 5 messages
Hi all, By default all the values in the result set are left aligned. But I want to align a column in a result set of a query to right side... Is it possible in SQL? Example: Charges 11145.00 ...
SQL 2K SP4 EM "%1 is not a valid Win32 application"
Michael_IIR -
6 May 2006 2:41 AM - 5 messages
Setup: - Server 2000 - SQL 2000 - Service Pack 4 Situation: The databases on this SQL 2000 server are running fine. (The websites that utilize it work fine too.) I open Enterprise Manager LOCALLY and drill down to any table within the any DB (real one we are using or even Northwind ...
How do I see all the tables and rows inside a SQL 2000 database?
Spin -
6 May 2006 2:02 AM - 4 messages
How do I see all the tables and rows inside a SQL 2000 database? Is there a way through the EM tool or must I use Query Analyzer? ...
New SQL Server Registration
sck10 -
6 May 2006 1:09 AM - 2 messages
Hello, I just installed SS2K5 Developer's edition (MSDN). I am unable to create a new SQL Server Registration. Any help with this would be appreciated. ...
Installing SS2K5 error with Visual Studio 2K5
sck10 -
6 May 2006 12:53 AM - 8 messages
Hello, I installed SS2K5 Developer edition and everything worked fine. Then I installed Visual Studio 2K5. When I open SS2K5, I get the following error: Unhandled exception has occurred in a component in your application. If you ...
Should "begin tran" hurt like this?
jxstern -
5 May 2006 10:18 PM - 5 messages
Here's my question: should wrapping this code in a transaction have ANY effect on its performance? Because I'm seeing some major effects, and did not expect it. OK, here we go: Have what looks like a fairly innocent SP that inserts a bunch of ...
Ascending Date Column Statistics "dbcc traceon( 2389 )"
achopp -
5 May 2006 9:50 PM - 4 messages
I am having trouble with query performance on SQL Server 2005. The database is a basic book ordering application. A simple one to many Orders to Order Items. The orders table contains 80,000 rows and the Order Items table ...
Can I use this thing to import data from a table into a view.
someone -
5 May 2006 9:00 PM - 2 messages
Hi all, I need to import data from a source table(table is in Sql) into a view. I need to insert, delete or update the view to make sure all rows in the view have the same data as the source table. Can you please give me how to design ...
Sum of data in colum (URGENT)
ITDUDE27 -
5 May 2006 8:36 PM - 2 messages
Hi, I was wondering is there a way to tally a whole colum. in other words, check the amount field for multiple records to get a total. What this projects in tails is checking if a sales rep has reached a target ...
Unique Index - Strange behavior
mnowosad -
5 May 2006 8:10 PM - 5 messages
Today, I came across this weird behavior in SQL Server, concerning unique indexes based on varchar columns. If you create a table like that: CREATE TABLE Names ( name varchar(32) not null ) then create a unique index based on the varchar column ...
Cannot open database "mydb" requested by the login.
cas -
5 May 2006 7:30 PM - 5 messages
Hi, I installed sqlserver 2005 express on windows server 2000 sp4. I made a new database ("mydb") with sql server Management studio express (not a mdf file). I also defined tables and i can make and execute queries in sql server ...
error: sql native client: login timeout expired
cas -
5 May 2006 7:17 PM - 7 messages
Hi, I installes sqlserver 2005 express on windows server 2000 sp4 (name=pen1800). When running this: 'sqlcmd -S pen1800 -U administrator' in a dos window as administrator, i have first to enter the password and then i get this error: ...
Connecting to named instance in Management Studio fails
kmart -
5 May 2006 5:22 PM - 2 messages
I have a remote server with a default instance of Sql 2000 and a named instance of Sql 2005. Whenever I try to connect to the named instance in Management Studio, it ALWAYS connects to the default instance. I am ...
reporting/archiving database?
param -
5 May 2006 4:45 PM - 5 messages
Hi all, We currently have a production database fast approaching about 15GB. It stores all types of data including transactional records, image columns for scanned documents etc etc. In addition to our production applications using this database, all our reports have been written to run of this database. ...
ram access
param -
5 May 2006 4:44 PM - 7 messages
Hi all, I have a 2-node SQl2000 cluster running on 2003 Ent Edition SP1. Do I need to do anything specific to make the server see and use all the 8GB RAM available? I know in Windows 2000 there was some type of command line ...
Static IP with SQL Server and WinXP ?
ARTMIC -
5 May 2006 3:36 PM - 2 messages
Hello Can anyone tell me how to configure SQL Server to handle static ip requests from the internet. The sql server is installed on a windows XP Pro machine. Is the above even doable? OR does the sql server need to be installed on the ...
PatIndex Pattern
cbrichards -
5 May 2006 3:33 PM - 3 messages
I am attempting to use PatIndex to find characters outside of the range of character codes 32 - 126, or in other words, find all characters in the ranges of 0 - 31 and 127 - 255. I have written the following so far: ...
Very slow when ColumnA = X AND ColumnB = Y
Marius Horak -
5 May 2006 3:21 PM - 4 messages
In the below SQL there is AND PRGM.Active = 'Y' The PRGM table has about 900000 records. The SQL finishes after about 40 minutes. If I remove AND Active = 'Y' it will finish under 10 secs. If I change AND to OR it will finish under 10 secs. ...
Function Suppressing Index
cbrichards -
5 May 2006 3:16 PM - 3 messages
I have the following query that needs to be rewritten (if possible) so that the clustered index on column "coldate" can be utilized. Any suggestions would be appreciated. I realize that getting the functions off the column is the goal, but I am not seeing how that might be done in this instance. Thanks ...
query
tolgay -
5 May 2006 3:15 PM - 6 messages
Hi, There is a table which contains the rows and I would like to create a query that can show the below result. Can a query do that? Thanks Table ------------------------------ Owner Cat Name 1 1 Kitap ...
export DBCC CHECKDB into table
Leon Shargorodsky -
5 May 2006 2:28 PM - 3 messages
Is there anyway to export DBCC CHECKDB results into a table? The only example I was able to find on Books Online is: INSERT INTO #tracestatus EXEC ('DBCC TRACESTATUS (-1) WITH NO_INFOMSGS') Please help ...
GHOST CLEANUP
Kevin Jackson -
5 May 2006 1:38 PM - 2 messages
SQL Server 2005 SP1 What is it and why has it been running for the past 3 hours with I/O rates as high as 50 MBps? We do not have autoshrink on, we have recently deleted a lot of records but ...
_WA_ entries in sysindexes
MO -
5 May 2006 11:44 AM - 7 messages
Hi, When I look at sysindexes, there are lot of _WA_% entries in there for my database. These are constraints I believe, created by checking 'Auto create statistics' option at the DB level. SOmewhere I read that if you see lot of ...
Conditional where clause, depending on parameter
Vicky -
5 May 2006 11:24 AM - 4 messages
I am looking for a way to create a query that, depending on the value of a parameter, builds the correct where-clause. This should be usable in a stored procedure. Example: parameter @ShowArchived select x, y, z from table_zyx WHERE ... ...
Script to find out the number of row in all the table of a database.
csajid -
5 May 2006 11:14 AM - 4 messages
HI, I am using following script to find out the number of row in all the table of a database is there any simple way out? if so pls mail me declare @TAB VARCHAR (20), @qu nvarchar (100) DECLARE TABALE CURSOR FOR ...
Database Mail
Roger Nygård -
5 May 2006 10:35 AM - 4 messages
MSSQL 2005 9.00.1399.06 Win2003 server I have configured database Mail, and tried the Sent Test E-Mail and it's working, sp_send_dbmail is working too When I do some testing on jobs and Notification/Operators on a specific ...
sqlservr.exe process getting large
postings -
5 May 2006 9:32 AM - 3 messages
Hi Today I noticed a SQL Server 2000 (SP4) process running on SBS 2003 taking up a lot of memory. I suspect it's a dodgy ASP.NET 2.0/1.1 app (that I wrote) that may not be closing the connections properly. ...
UNIQUE constraint with multiple fields
Zoro -
5 May 2006 8:36 AM - 4 messages
I need to ensure that a set of 3 fields will be unique. I know you can achieve this with a primary key constraint, but this is not possible in this case, as the key is different. I can see in the help how to create a unique constraint on a single ...
Can anyone help me in this?
sridhar -
5 May 2006 7:05 AM - 3 messages
I want to write a function or procedure that deletes any characters other than aplhabets. At the same time i want to update a cloumn in the same table(say column changecode with value 1 if my function deleted any of the characters) ...
Result columns with fixed width
SouRa -
5 May 2006 6:59 AM - 2 messages
Hi all, Can I save the result set of a query in ASCII format and each column should be in fixed width (ex. Firstname column width should be 20, ID width 5)... please advise... Thanks, Soura ...
sql2005 database mirroring
adam -
5 May 2006 6:55 AM - 3 messages
hi, i'm new to this group. i wonder if i can get answers to my question here, cos i cant find a newsgroup with database mirroring. i have two servers : pSQL - principal mSQL - mirror Have successfully create the endpoints at both servers. ...
sqlserver error 18456
don -
5 May 2006 4:07 AM - 3 messages
user created an access database and was able to login and perform queries. they gave the database to another user and the second user gets the sqlserver 18456 error login failed for user lccc/username. Odbc was setup successfully on second users pc. Why can one user access the database and the second user ...
Is renaming a SQL database easy?
Spin -
5 May 2006 3:43 AM - 4 messages
Is renaming a SQL database easy? Can it be done via the GUI only or must one use SQL transact statements? ...
Urgent: Server Down for maintenance: SP4 Analysis Services
CC -
5 May 2006 12:02 AM - 2 messages
Hi, I'm getting this error while installing SP4 for analysis server on a prodution server that is down for maintenance right now: error during the move data process: -132 This happens when the setup is starting to copy files about 6% done. ...
Suggest: SQL Server 2005 Book
SP -
4 May 2006 11:13 PM - 3 messages
Hi, If anyone can suggest a good book on SQL server 2005 for DBA. I am looking more in terms of administrating server, performance tuning, security than programming in .net. Thank you in Advance ...
backup causes file size to grow
doug -
4 May 2006 10:24 PM - 5 messages
I backed up my database using the sql command Backup database xxx to disk = 'yyy' When it completed the file size of my database approximately tripled. Did I just corrupt some data? The application appears to continue to run ok. I ...
select by linked server lost records
raf_go -
4 May 2006 9:27 PM - 2 messages
hi I have small problem. When I try something like : insert into #tab1 select * from server1.base1.dbo.tab1 where ..... Sometimes ( it is unusual) this query lost some records ( realy on server1 in tab1 is 500 records but insert only 498). ...
new sql server
Eli Milkova -
4 May 2006 9:21 PM - 7 messages
Our multiinstance multidatabase box (ML 350 4 GB RAM W2003 SE and SQL2000 SE SP4) will be replaces and a research is going for new sql server. Optionally wed like to have high avaiability of all instances and databases. Any advice ...
SQL Backups Missing Data
Mark -
4 May 2006 8:48 PM - 2 messages
Hello everyone, I'm kinda stuck. On the 20th of april I ran a select statement for 2005 on a table. All the data was there. something happend over that weekend and now there is no data for 2005 in that table. I have 3 backups on from the 3rd, 14th, and ...
Adding delete statement in a dts package script to delete records
Aboki -
4 May 2006 8:46 PM - 2 messages
I am using a dts package to move tables from one server to another and will like to know how I can add a delete statement that can delete records more than a year old from a particular table in the source database before the dts ...
Sql Code generation tools
helpful sql -
4 May 2006 7:07 PM - 16 messages
Hi all, Are there any good Sql code generation tools out there in the market? If not can you please give me tips or sample code for creating one? I need to automate code generation for data integration. Here is what I ...
JDBC driver for Oracle
Joe K. -
4 May 2006 7:02 PM - 2 messages
I have Windows 2003 and SQL Server 2005 with several databases. What are the JDBC driver for Oracle that are compatible with Windows 2003 and SQL Server 2005? Thank You, ...
CREATE STATISTICS locking up tables?
Zen -
4 May 2006 6:42 PM - 2 messages
Hi I'm just wondering if executing CREATE STATISTICS (full scan) would cause problems to the user operations by locking up tables or rows. Thanks! ...
Convert Money as String $XX.XX in output
ShaneFowlkes -
4 May 2006 6:34 PM - 5 messages
How can I convert or format a Money defined field to look like $xx,xxx.xx? My data is stored like 50000.99 but I'd like to see $50,000.99 in the query results. I tried using CAST (SELET CAST (MyField As Money) As MyField FROM ...
Service Account & Local System Account Documentation
SQL Newbie -
4 May 2006 5:21 PM - 3 messages
Hello, I am looking for some documentation stating pros and cons for using domain account over local system account for SQL SERVER 2000. I found nice article posted for 2005 from Microsoft but nothing really over 2000. I am specifically looking for something from Microsoft. Even BOOKS ONLINE did not ...
database mirroring
john -
4 May 2006 5:17 PM - 5 messages
Does anyone know if you can read the mirror database after installing sql 2005 sp1. I did setup mirror config before sp1 came out, but at that time the mirror db was not avilable to read, but I heard then in sp1 it was going to be ...
Upgrading MSSQL 2005 Eval to production standard server
withersd -
4 May 2006 4:46 PM - 2 messages
I understand the license requirements for this. My question is, what ist he best way to upgrade my "Eval" version that is going to expire to MSSQL 2005 Standard w/o losing any DB data etc? In place upgrade with a standard MVL cd? or uninstall the Eval version with backups of ...
connecting msde to java code
saikiran2012 -
4 May 2006 4:35 PM - 2 messages
I have a java code which has to read from the database ,I am running msde on a local machine how can ,I connect to tthis database using java.I am completely new to msde should I use jdbc drivers or connect through tcp connection. ...
Full-text search with German umlaut
RobRoma -
4 May 2006 3:53 PM - 3 messages
Hello everyone! I’m using the full text search with the German language and it works fine in mapping the German umlaut "ü" into "ue", but unfortunately the other direction doesn’t work (the search for words including "ue" does not match ...
3.33 millisecond accuracy in datetime
lairdnet -
4 May 2006 3:49 PM - 2 messages
I'm still not clear on the technical reason why datetime values are accurate to 3.33 milliseconds. I think I understand that it has to do with the fact that what is stored for the time value is the number of ...
defrag database
Andre Gibson -
4 May 2006 3:45 PM - 4 messages
Hello all Is there an easy way to see if my db needs to be defraged? Thanks ...
Newly created stored procedure => master db
Lisa Tanenbaum -
4 May 2006 3:43 PM - 5 messages
I have upgraded my SQLExpress to SP1 but since doing this I am not able to create stored procedures under the database that I created. It seems as if any new procs are created in the master database. If I create a new proc, it is not displayed under the stored procedure ...
Issues with deleting XPs
Michael MacGregor -
4 May 2006 3:41 PM - 2 messages
We were recently audited and asked to get rid of the following XPs: xp_cmdshell xp_regaddmultistring xp_regdeletevalue xp_regenumvalues xp_regread xp_regremovemultistring xp_regwrite But we found a possible problem with xp_regread and received the following error messages: Server: Msg 2812, Level 16, State 62, Line 52 ...
How to keep sql instances in 'Object Explorer' pane?
John -
4 May 2006 1:51 PM - 3 messages
Hi, with EM you could create server groups and register servers. EM would retain this list. however with SQL 2005, it uses a little dialog box with a drop down box to make such connections. Doesnt 2005 allow the classic setup ...
Does SP4 client work OK with SP3a server?
Ron -
4 May 2006 1:42 PM - 3 messages
Can a SQL2000 SP4 client connect without problems to a SQL2000 SP3a server? We are planning on updating all the client pcs to SP4 before we upgrade the servers. Thanks Ron ...
Where are the LogReader / Distribution jobs (and other stuff) under SQL 2005?
John -
4 May 2006 1:25 PM - 2 messages
Hi, I have SQL 2005 Developer edition installed on my computer at home. If i VPN into my work computer and try and observe activity of the SQL 2000 box at work, I am unable to see the Snapshot/LogReader/Distributer agent status ...
Gather Format and Store - Right or Wrong
rlm -
4 May 2006 12:56 PM - 2 messages
The IT group that I work with has the habit of gathering data, formatting (i.e. in reports) and then storing the same formated data in the same database. I think the practice is wrong. I think the activity is fundamentally ...
sql server 2005 developer edition
Waldo -
4 May 2006 12:40 PM - 2 messages
Hi I'm using sql server 2000 developer edition in my class. I 'm thinking to upgrade to sql server 2005 deveoper edition. But I'm not sure about the system requirements. Somethimes I read that the developer edition is only ...
database (Restoring...) forever??
Alex D. -
4 May 2006 12:12 PM - 13 messages
yesterday I restored a backed up database and it worked ok...the only problem is that the status of the database in the Server Management Studio is: database (Restoring...) since yesterday and I tried rebooting the pc but still the same....anu ideas?? ...
Attach a read-only restored database
Parv -
4 May 2006 12:05 PM - 4 messages
hi all can i attach a read only restored database. I restored a database Test in Stand by Mode. After that i detached that database and while restoring i m getting msg "Cannot attach a database that was ...
SQL Server Agent Error 14258
N. Schweikart -
4 May 2006 12:01 PM - 4 messages
Hi, we have an MSSQL DB-Server with OS Windows 2000 and SQL Server 2000. There are about 45 databases on this server. Two weeks before we haven't had enough place on the C-Partition (Installation path from SQL Server) and ...
How to check SP in SQL server?
sunkers -
4 May 2006 9:39 AM - 5 messages
Hi all, how to check the lastest sp that has been installed in SQL server ? thanks KS ...
MS SQL 5.0
kumar -
4 May 2006 7:39 AM - 3 messages
Hi, We are having a migration job to do. The customer is saying that the SQL Server version 5.0 I never heard this version before? Is there any such version there last time? I knew the version ofrom 6.5 onwards. ...
Transaction log or Database - Complete
ina -
4 May 2006 7:35 AM - 7 messages
Hello, I set up my database backup; So it is set to FULL and I choose Database -complete Do I need to do the transaction log backup as well, normally when I select Database - complete automatically the log file is updated ...
How often backup the master
ina -
4 May 2006 6:36 AM - 9 messages
Hello, I would like to know how often to backup the system database. scheduled or once a week. Ina ...
backup plan
ina -
4 May 2006 6:16 AM - 4 messages
Hello, I would to do a backup plan and I would like to know if someone can help me with some advice? What I have done until now is to do the transaction log (10:50 PM) before the data backup (11:00) PM. ...
Join Performance
David -
4 May 2006 3:42 AM - 2 messages
All I have a quick question regarding the performance of a join. I am performing a join between two tables and one table has the opid column as VARCHAR(100) and the other table has the opid column as VARCHAR(8). Will ...
64bit Primary with 32bit Secondary SQL 2005
Brandon -
4 May 2006 12:01 AM - 2 messages
Currently I have a standby server which is kept in synch from the primary via log-shipping. Both are running SQL 2005 Standard sp1, on Windows 2003 Server w/sp1. My primary is 64bit capable, but my secondary is not. Are there any ...
Cannot connect to SQL Servrer 2005 remotely using another account than sa
Marc -
3 May 2006 11:55 PM - 4 messages
Hi there, I set up an SQL Server 2005 Enterprise Edition, so it is listening on the network. I can login successfully from a remote machine using osql: osql -H sqlhost -U sa Password: XXX 1> However I created another user "test" (SQL Auth.) and also a database ...
Restore error in SQL Server 2000 SP4
Peter -
3 May 2006 11:54 PM - 14 messages
I'm restoring a backup (.bak) in SQL Server 2000 SP4 and getting the error: The media family on device ".....bak" is incorrectly formed. SQL Server cannot process this media family. RESTORE DATABASE is terminating abnormally. ..bak contains 3 files: xxx_log.log, xxx.mdf, and xxx_1.mdf. ...
Using SQL Server and C# to make simple version control system
bob_jeffcoat -
3 May 2006 11:33 PM - 4 messages
Hello, I make a CAD program and I'm planning on creating a simple product database to control the versions of my customers CAD files. The database will only have a couple of tables, the main one having these ...
Help with query rewrite
cbrichards -
3 May 2006 11:04 PM - 6 messages
I have the following nonindexable query due to the "<>" operater. Column "id" in the following scenario is a clustered index. DECLARE @tid SET @tid = 1000 SELECT t.id FROM table t WHERE t.id <> @tid Is there a way to rewrite such a search condition so as to make it an ...
Report on successful sql logins
James Wuerflein -
3 May 2006 10:50 PM - 3 messages
Looking for how to create a report for sql'05 to see who's logging in succesfully and then failed user logins as well perhaps on a second report. Is there a way to capture logins historically with just sql server? How do you set this up? Could someone point me in the right direction or, possibly an example? ...
Query Analyzer tool?
Dabbler -
3 May 2006 9:13 PM - 3 messages
How do users who use a remotely hosted (3rd party webhost) SQL Server 2005 get the Query Analyzer tool to create queries? Thanks. ...
Uninstall SQL 2005 SP1
Mark -
3 May 2006 8:00 PM - 2 messages
Hi, After installing the SQL Server 2005 SP1, we have had problem after problem with SSIS and Reporting Services. Does anyone know how if the service pack can be uninstalled? Is so how? Thanks, Mark ...
questions about sqlserver express 2005
phil -
3 May 2006 7:15 PM - 5 messages
Hi, I didn't find a group for express 2005, so i use this one. 1)i wish to know what's the difference between a .mdf file and a sqlserver express 2005 database. Is the .mdf file independant (linked to) of the ...
SQL statement
Lillian -
3 May 2006 7:13 PM - 4 messages
I have a lots of table name with spaces in between in my SQL server, because this is from Microsoft Access, I import to SQL server, but I am writing ASP, so here is the statement like this ..... conn.Connectionstring = ...
Enteprise Manager - Database folder hangs...
Eric -
3 May 2006 7:02 PM - 8 messages
Somehow we could not use EM to access our database. Everytime I click on the box, EM just hangs. The thing is: Everything worked before, and the problem just happened a few days ago. We have a bunch of ASP .Net applications and they are working fine ...
Evaluate this backup script
PSPDBA -
3 May 2006 6:43 PM - 17 messages
I've just taken over a few SQL Servers as a DBA, and I'm trying to learn as much as I can. The following script is currently being used to do a full backup on the databases. I'm havnig a problem ...
Media Center XP OS and SQL 2005 Editions
Timothy Ford, MCSD -
3 May 2006 6:32 PM - 4 messages
I am looking into purchasing a new laptop and can not find any information on which editions of SQL 2005 are supported on Media Center O/S. I know that Express is supported, but was looking to install a beefier version if at all ...
schedule a task
JIM.H. -
3 May 2006 6:16 PM - 2 messages
Hello, How can I run one of my stored procedure every 30 minutes in SQL Server 2000? Thanks, ...
issues using MS Access with SQL Server 2005
Dabbler -
3 May 2006 5:44 PM - 4 messages
I'm trying to help my clients configure MS Access to run queries against a SQL Server 2005 on a hoste providers server. I'm using Access 2002 (10.6771.6735) SP3. When I try and design a view I get ...
SQL Server Switch
Matthew -
3 May 2006 2:19 PM - 2 messages
I had both sql 7 and 2000 installed on my pc. I uninstalled both, and reinstalled 7, and now during the install it tells me it is detecting a previous install of 7.0, and it won't let me install the service manager ...
Multiple backups happening
Gaurav -
3 May 2006 1:49 PM - 3 messages
I had some problems configuring a backup of a sql server. The problem was access rights to the network share. Now when I resolved it, my SQL server is backing itself twice on the same share with two different file names. There is a great possibility of my trying to configure the ...
from sql 2005 to sqlexpress 2005
Alex D. -
3 May 2006 1:02 PM - 6 messages
Is there any way to export/import/copy a database from sql 2005 to sql express2005? Thanks. ...
Pooling issues
Tim Greenwood -
3 May 2006 12:51 PM - 5 messages
We have been fighting with this for some time now. The web group keeps setting the max connections in their connection strings to "2500" yes you read that correct.....that seems a little insane. BUT, we've witnesses the ...
Query Performance
Leila -
3 May 2006 12:02 PM - 5 messages
Hi, I have one query for two groups of tables(3 tables). These two groups of tables have the same data and schema but second group has been partitioned based on OrderDate Column. By setting "Statistics IO On" I see very less IO ...
SP running for long
Vikram -
3 May 2006 11:53 AM - 2 messages
Recently i put sql profiler as CPU was showing 100% usage and system is slow. I found some sps were runnnin for more than 2-3 hours. I checked remote query timeout and its still set to 600 sec. How is it possible ? ...
newbie - have backup file and trn file - how do I get it up and going?
David Smithz -
3 May 2006 10:45 AM - 3 messages
Hello there, I have a project to look into where I need to look into an MSSQL database. I have been sent a file that contains a BAK file and a TRN file. I am told this is a dump of the MSSQL database. ...
Are Stored Procedures bad?
the friendly display name -
3 May 2006 10:23 AM - 2 messages
I have always thought that you should use stored procedures when ever possible. But, after reading this: [link] My world view is shackled. Are stored procedures good or bad? ...
restore single table
maxzsim via SQLMonster.com -
3 May 2006 9:19 AM - 5 messages
Hi All , Is it possible to restore just a single table from a particulare db's backup ? kindly advise tks & rdgs ...
Change from char to varchar and RTRIM
Pieter Coucke -
3 May 2006 8:49 AM - 2 messages
Hi, I have a big database with most of the columns having the datatype char (char(10), (char(50) etc.) I would like to change all these columns to varchar (varchar(10), varchar(50), ...), and have all the spaces on the right trimmed of. So ...
Help! Something adds 1 hour to my datetimes! :-S
Pieter Coucke -
3 May 2006 8:28 AM - 3 messages
Hi, For some reason, somewhere in my application 1 hour is added to my dates, depending in which time zone the application is run... Because I don't have a clue where this happens, I posted this to the three ...
rtf
Hrvoje Voda -
3 May 2006 8:08 AM - 2 messages
I'm filling richtextbox with data. I want to save it into database, but I don't know wich type of field shoul I use in table to store that kind of data? ...
Can not insert into table that have IDENTITY
afang -
3 May 2006 8:03 AM - 4 messages
Hi All, I have 2 table. Table one is CREATE TABLE [coba] ( [id] [int] IDENTITY (1, 1) NOT NULL , [desc] [char] (10) ). Table two is CREATE TABLE [coba2] ( [id] [int] IDENTITY (1, 1) NOT NULL , ...
|
|||||||||||||||||||||||