|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
32 bit DLL in SQL Server 2005 64 bit
Ganesh Muthuvelu -
4 Nov 2006 5:50 PM - 3 messages
Hello, I have been using a 32 bit DLL in SQL Server 2000 extended stored procedures and it works just fine. Now I have upgraded my SQL Server 2000 32 bit to SQL Server 2005 64 bit edition. The same extended stored procedures now give error when I call them using ...
OS requirements for 2005.
ChrisR -
4 Nov 2006 4:06 PM - 4 messages
Howdy all. Im considering buying a new home PC, and would like to install the developer edition of SQL 2005 once I have it. Most new PC's that Im looking at have either WIN XP Home or Media Center. I see the requirements ...
How to solve the remote connections error
Krishna -
4 Nov 2006 11:50 AM - 5 messages
Hi, How to rectify the following error? An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. ...
Lock management in SQL Server 2000
z1hou1 -
4 Nov 2006 10:39 AM - 5 messages
Hi, I am a newbie to SQL Server 2000 and have issues with lock management. How would I know that a lock is already in place in SQL Server 2000 while I am attempting to update a record, or insert a record in the ...
event 17055 error code 18452 user (null) not associated with trusted account
kevin-helena-dana -
4 Nov 2006 7:56 AM - 14 messages
Dear All, I am new to this newsgroup so please forgive me if I am in the wrong palce. The subject line describes my problem in a nutshell. I am getting and event id 17055 from one instance of our SQL Server ...
Server Authentication Certificate and NetBIOS name Computer name
Saucy Sass -
3 Nov 2006 10:37 PM - 3 messages
I want to issue a "Server Authentication Certificate" to a computer running SQL Server Express on my network (a simple "Workgroup" network, not a domain and no Active Directory). I read this article: [link] ...
Time for requests
tshad -
3 Nov 2006 10:37 PM - 2 messages
Is there a way to track the time it takes to handle a request? I am trying to find out why my loging on from my web page is taking so long. The Logon table is not large and there are 3 indexes on it. ...
Another Backup Question
Scott -
3 Nov 2006 10:32 PM - 2 messages
I am using SQL Server 2000. I have a database that is 230GB that I backup nightly using the Maintenance Plan. Up until last week it was working fine and was completing in less than two hours. Last week I applied the monthly ...
Database restore error
alejandro -
3 Nov 2006 9:51 PM - 4 messages
I've been trying to restore a database from a .bak file, but I receive the next error message: RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013) An internal consistency error occurred. Contact Technical Support for assistance. [SQLSTATE 42000] (Error 3270). The step failed. ...
Bulk insert causing timeout
nicholastoze -
3 Nov 2006 6:53 PM - 2 messages
Hi, I'm using Bulk Insert to load a file about 1.5GB in size. When I do this, another process which is continually reading and writing to other tables in the same database gets a connection time out error. Why might ...
Stored Procedure Size
MS User -
3 Nov 2006 6:25 PM - 3 messages
SQL 2K I was looking at the system tables to find out the size of all my stored procedures and couldn't find one. I found the undocumented system SP :- sp_MSindexspace , but this will work ...
SQL Server is not releasing Extended SP DLL
Mr.Clean -
3 Nov 2006 5:53 PM - 8 messages
During a Wise Installation upgrade of our software, we are renaming a directory that contains our ExtendedSP DLL. We issue a DBCC TSWSQLXP(Free) call before doing the rename, yet SQL Server, still "holds on" to that DLL. We install a new version, and the ListDLLs ...
Restricting abilities of the agent
WANNABE -
3 Nov 2006 5:47 PM - 7 messages
HI, I really hope someone can help me here. I have setup an account to be the Agent account and added it to the SA role. I also need to allow Analysts the ability to create and manage DTS packages and jobs. I've just ...
NVARCHAR(MAX) and Dynamic SQL
cbrichards -
3 Nov 2006 5:24 PM - 7 messages
I have a large dynamic sql string that varies in length. I am running SQL 20005 Standard edition, version 9.00.2153.00, SP1, on Windows 2003. I am attempting to use, DECLARE @SQL NVARCHAR(MAX), since NVARCHAR(MAX) will ...
Transaction log problem
Hitesh -
3 Nov 2006 5:07 PM - 9 messages
Hi, dumb dba question... I have a db that is 40gb big. I needed to change the col. name and datatype of one col from smallint to int. So I tried EM (which is the dumb dba way).. and now my transaction log ...
Boolean ?
Gabriel -
3 Nov 2006 4:56 PM - 8 messages
Hello, Is there a way to define a boolean with SQL Server 2005 (Express) Thanks, ...
Query multiple fields at once???
kennedystephen -
3 Nov 2006 4:46 PM - 5 messages
I have a table with 10 fields. I want to select any row that contains the word "bob" in any one of the 10 fields. I've been writing this query by checking each field individually connected with an OR ...
SQL Server alerts Database Mail - SQL Server 2005
Joe K. -
3 Nov 2006 4:42 PM - 2 messages
I have configured and tested Database Mail on my SQL Server 2005 database server. I have several database maintenance jobs set up on the SQL Server 2005 database server. What are the procedures to add alerts to these jobs if they fail using the ...
Help - sp_help_revlogin does not work in 2005
tootsuite -
3 Nov 2006 4:37 PM - 6 messages
I compiled the sp_help_revlogin code on my 2005 server. However, when I try to execute it I get: Msg 208, Level 16, State 1, Procedure sp_help_revlogin, Line 12 Invalid object name 'master..sysxlogins'. This has always worked fine in 2000, but apparently one of the ...
master table rebuild error
coenzyme -
3 Nov 2006 4:15 PM - 4 messages
Hello everyone, When attempting to run a sqlservr.exe –c –m command I receive the error message “Your SQL Server installation is either corrupt or has been tampered with (SQL Registry Version Not Same As Server). Please uninstall then re-run setup to ...
How do I kill a restore?
Michael Gorsuch -
3 Nov 2006 2:23 PM - 6 messages
Question: I have a few databases that were told to restore via a script. They've been stuck in a 'Restoring...' state for two days now, and I need to kill it. What can I do from administration standpoint to stop this? ...
Agent not running?
hals_left -
3 Nov 2006 1:52 PM - 6 messages
Hi I am trying to run na backup and when I run the job manually I get an error SQL-DMO State 42000, Error 200225 SQLServerAgent is currently not running and cannot be notified. In the event log I get these two, ...
msdb sysmail_attachments_transfer - very large, but 0 records
rfisch -
3 Nov 2006 12:09 PM - 7 messages
Our SQL server 2005 has a system table in the MSDB database called sysmail_attachments_transfer. The management console summary report shows almost 5 GB of data for the table with 0 records. Table Name # Records Reserved Data ...
Query to return individual table sizes of all tables in a DB
Mark Kingswell -
3 Nov 2006 10:05 AM - 2 messages
Hi Is there a query that can do this? Regards Sarah ...
MS SQL Server 2005 Express Edition Installation.
csajid -
3 Nov 2006 10:03 AM - 3 messages
Hi, I want to install MS SQL Server 2005 Express Edition. can any one guide me the installation process of SQL Server 2005 Express Edition and it's Hardware Requirment. It will be more useful if get any other information on related ...
SQL Server 2005
keymone -
3 Nov 2006 9:06 AM - 2 messages
Hello! i have sql server 2005 installed(not express) how can i enable user instances there? sp_configure 'user instances enabled','1' not working :( MSDN says that sql server 2005 does not support that command anymore but i don't know if it means that it doesn't support user instances at ...
Unknown Heavy Load?
Dominik Amon -
3 Nov 2006 8:38 AM - 7 messages
Hello! Since two week's, our SQLServer2005 Express seams going crazy. There's a always a 30% CPU usage. We are unable to track thea reason, bebause the activity monitor in Management Studio Express display's an empty list Even the SQLLog is an emtpy log. ...
Multiple TempDB files for Multi_CPU
JT -
3 Nov 2006 6:15 AM - 8 messages
Hi all, I have a clustered sql server 2005 64 bit on a SAN. The two nodes each have quad dual core XEON CPU's. TempDB is currently on a dedicated RAID 1 array in the SAN (two 72GB 15K rpm discs). I have read that it is wise to ...
How to estimate SQL database growth when new fields are added?
Anjali -
3 Nov 2006 6:06 AM - 4 messages
I need help regarding calculation of database size growth. Here is my query: Q1 We have created two SQL databases, databaseA and databaseB; they are mirror images of a databaseC which is a non - SQL database. DatabaseB has been altered to accomodate 3-4 new fields. We need to ...
SQL 6.5 to SQL 7 Trigger problem
Jason Huang -
3 Nov 2006 3:35 AM - 2 messages
Hi, When I transfer a SQL Server 6.5 database to a SQL Server 7.0, it's fine for most tables in that database. However, those Triggers in the SQL Server 6.5 were not transferred to the SQL Server 7.0. ...
Importing within SQL Server Express without Data Transformation Services
John Hackert -
3 Nov 2006 3:11 AM - 6 messages
I'm sorry to repost this from microsoft.public.sqlserver.msde where I had recently submitted this, if anyone would have noted, but I still can't resolve the seemingly simple task of importing from one database to another within even the same instance of SQL Server Express. I ...
best way to move database from development to production
sharman -
3 Nov 2006 2:31 AM - 12 messages
Hi, What's the best way to move a database from development server (once you have done all the testing and everything runs fine) to the production server? Thanks in advance. ...
problem in sql 2k5 editing data in mgmt studio
Jeremy -
3 Nov 2006 12:32 AM - 5 messages
I have a 1-row table containing a version ID column and a datechanged column. The datechanged is updated via a trigger when the versionID changes. I used to use ent mgr to open the table & update the versionID ...
Help, 2 instances - questions
tootsuite -
2 Nov 2006 11:03 PM - 7 messages
Hi, The other DBA here set up a server with 2 instances of SQL Server 2005. I'm not sure he set it up right, because when I look at the file structures, there are 3 directories: MSSQL.1 MSSQL.2 ...
Deadlock Issue.
LineVoltageHalogen -
2 Nov 2006 10:22 PM - 7 messages
Greetings All, here is the ddl to create my test: create table Parent ( PPK1 decimal(10) not null, PPK2 decimal(9) not null, RIAmt decimal(28,10), CONSTRAINT RII_PK PRIMARY KEY CLUSTERED (PPK1, PPK2) ) go create table Child ( CPK1 decimal(10) not null, ...
Sql05 cannot claim back text diskspace either
Zeng -
2 Nov 2006 10:16 PM - 7 messages
I have read at a few places that sql2k cannot claim back the text space used for data, we just moved a database created in sql2k to sql05 Enterprise Edition and it still cannot claim back the text space. At one time, the ...
Publisher is empty under Replication Monitor - Publisher.! But replication is still running fine..
Query Builder -
2 Nov 2006 7:50 PM - 5 messages
I have a wired situation..! I set up transactional replication on one of my development server (SQL 2000 Dev Edition with sp4). It is running fine without any issues and all of a sudden, i noticed in my repication monitor tab under Publisher where I usually see the ...
Run SQL2k SE 32-bit on 64-bit machine?
Mitch -
2 Nov 2006 7:50 PM - 2 messages
Is this possible? If so, are there any OS configurations that need to be set ahead of time? When attempting to install, I am getting an error that says: The image file autorun.exe is valid, but for a machine type other than the ...
DB attaches as read only
Conan Kelly -
2 Nov 2006 7:27 PM - 5 messages
Hello all, I detached one of our DB's from one of our servers, copied the data & log files to another server, and then attached it there. It attaches as Read Only. When I go into the DB's properties and try to change the Read-only option, I get an error message: ...
Expensive logical reads on INSERT - SQL 2005
Robert -
2 Nov 2006 6:55 PM - 5 messages
Hi, I have an insert that is taking about 500ms to execute. This is on a table with about 1,000,000 rows. The table has a number of indexes, a PK, one default value but no relationships. The profile displays logical reads=31 writes=6. ...
Expensive logical reads on INSERT statement - SQL 2005
Robert -
2 Nov 2006 6:51 PM - 2 messages
Hi, I have a query that inserts a single row into a table this table has 1,000,000 million plus rows with multiple indexes. The table also has one constraint (default value) but no relationships. When profiling the insert is quite expensive (500ms). The profile breaks ...
Maintenance schedule in 2005
Leon Shargorodsky -
2 Nov 2006 6:48 PM - 2 messages
In SQL 2005, is there a way to specify two (or more) different schedules within one maintenance plan? Or, do I have to create different plans to be ran on different schedules? Thank you in advance for your help! ...
DBMail in SQL 2005
stoney -
2 Nov 2006 6:43 PM - 2 messages
Hi, DBMail in SQL 2005 uses port 25. Is there way that could be changed or not? Currently we block port 25 so am unable to use DBMail in SQL 2005 Thanks in advance....... ...
Overlapped I/O operation is in progress
Anne West -
2 Nov 2006 5:46 PM - 3 messages
SQL Server 2000. I removed SQL Server using Add/Remove Programs, rebooted the server after the removal and now I am reinstalling SQL Server when I get this error. Any suggestions on what is happening and how to fix it? I am ...
Migrating to SQL 2005
Kart -
2 Nov 2006 5:45 PM - 4 messages
Hi, We are migrating from SQL 2000 personal edition to SQL 2005 developer edition a 120 GB database. This database has around 1000 stored proc's and 150 DTS packages. I have read that running SQL Upgrade Advisor on the source would list ...
SP to generate script that Creates/Alters/Drops an Existing SP
CBKowitz -
2 Nov 2006 4:55 PM - 4 messages
Using SQL Server 2005 and they took away the 'wizard' that allows you to create a script file that will drop and create any number of existing stored procedures. You now have to do this in seperate steps. ...
Add TCP/IP and named pipes protocls
sauve mark -
2 Nov 2006 3:49 PM - 2 messages
Hi, I have a trouble to connect to my local SQL Server 2005 instances. I have noticed that "SQL Server Configuration Manager \ SQL Native Client Configuration \ Client Protocols" is empty, I guest TCP/IP and named pipes entries should exist ! ...
sql use 2 gb memory
someone -
2 Nov 2006 3:28 PM - 4 messages
hi, just notice my sql 2000 use 2 gb memory, how to check what process/query use and not release the memory and fix it? thanks... ...
Query problem
akira-888 -
2 Nov 2006 2:59 PM - 3 messages
I am using SQL SERVER 2005 FT-enable database, repleat same query it returns the results are expect,but try five times later, it returns record is no data, Has anyone seen this issue ? THANKS!! ...
AutoGrowth - Which data file does SQL Prefers to auto grow & why ?
Ranga -
2 Nov 2006 2:59 PM - 2 messages
Win2k3, SQL 2000, SP4 If we have multiple datafiles in a filegroup, lets say 8, How does SQL distribute data ?(Will all data for a single table will go in one file or will it be spread) When there is need for space are all files auto grown uniformely OR just one ...
sql2005 moving from x86 to x64
param -
2 Nov 2006 2:42 PM - 14 messages
Hi all, Can anyone share any results on the performance gain they experienced in moving from x86 to x64? Is it significant? We want to assess if it is worthwhile undertaking that project. TIA! ...
Script
Erencan SAÐIROÐLU -
2 Nov 2006 2:23 PM - 4 messages
Hi Folks, I need a script that it'll changed varchar field to nvarchar a table which i pass it's name via parameter. I generated it but it'll raise exception when a field has foreign key etc... I don't want to spend more time to this work. Do you have a script like ...
Read and Delete Mail in SQL 2005
Terry -
2 Nov 2006 1:56 PM - 2 messages
Does anyone have script or a CLR assembly to read and delete email in SQL2005? I don't want to enable SQL mail or install Outlook. Thanks in advance Terry ...
Indexes
Michael Knee -
2 Nov 2006 12:56 PM - 2 messages
Hi - Can anyone tell me the best approach to indexing a database I am using for reporting? I have a data table & a time table(below), the time table has a timeID field with an incrementing integer ID & a clustered Index on this field. ...
how to find an object ?!
bajopalabra -
2 Nov 2006 12:36 PM - 6 messages
hi i forget completely how to find an object in sql 2005 ? don't remember where is that function !!? where is it ?!! thanks ...
SQL Server 6.5 backup file to restore into SQL Server 7
sathish -
2 Nov 2006 12:24 PM - 2 messages
I have a Sql Server 6.5 Backup file(.DAT file) which is being copied manually from the location where the database device has been created. Now I dont have MS Sql Server 6.5 running or the installation CD. Any ...
Problem in Restoring .DAT file to MS Sql Server 7.0/2000 Database.
brs.sathish -
2 Nov 2006 12:16 PM - 2 messages
I have a Sql Server 6.5 Backup file(.DAT file) which is being copied manually from the location where the database device has been created. Now I dont have MS Sql Server 6.5 running or the installation CD. Any ...
Log Shipping on two different networks.
csajid -
2 Nov 2006 10:48 AM - 8 messages
Hi, I have two servers with MS SQL Server 2000 Enterprise Edition installed on it. These two servers are on different networks, means you can say that these two servers are having two different network ...
Collation Error
Cenk FIRAT -
2 Nov 2006 10:14 AM - 4 messages
When I change db collation sql says "You cannot change database collation" "The object XXXX is dependent on database collation.". Is there any way to change database collation? (without creating new database from script) thank you ...
select row number in a result set as a column in the set
Velislav -
2 Nov 2006 9:38 AM - 4 messages
Hi, Suppose I have a query returning the following result set: ID Name Column2 -------------------- 5 Johnny 10.3 8 Peter 12.99 9 Mary 99.00 ...
System DSN causes SQL to stop accepting connections
Dave Rowley -
2 Nov 2006 8:40 AM - 4 messages
Hello, I have an ASP.NET 2.0 application running on IIS 6 on a 2003 server. I have SQL2005 SP1 installed. Everything runs ok until I attempt to create a system DSN to the named instance of SQL that I wish ...
SQL server 2005 express
Pola -
2 Nov 2006 7:43 AM - 3 messages
Hello, We installed SQL server 2005 express and we can't run the script that priviously was running on MSDE 2000. When we run the script from command line: osql -i C:\xxx.sql -E and we got the following error: ...
sp_help returns error on trying to view some db table data -The object 'x' does not exist in databas
aurimas.norkevicius -
2 Nov 2006 6:38 AM - 3 messages
the error is The object 'x' does not exist in database 'y' or is invalid for this operation. ...
Transactions across multiple databases in Stored Proc
MarkusJNZ -
2 Nov 2006 12:26 AM - 5 messages
Hi, I have a Stored Proc which will be used to call embedded stored procs. Some stored procs exist in a different database from the one making the inital call. e.g USE DefaultDatabase GO CREATE PROCEDURE BootStrap BEGIN BEGIN TRAN UpdateRecords ...
Copy DB from 2005 to 2000
Leon Shargorodsky -
1 Nov 2006 10:28 PM - 8 messages
Is there a ligitimate way to copy database (ALL objects, not just tables and views) from SQL 2005 to SQL 2000? Thank you for your help! ...
Defrag a partition with a SQL database
CK -
1 Nov 2006 10:26 PM - 12 messages
Is it problematic at all to defrag a partition conaining a SQL database? ...
Config changes on SQL 2k don't stick.
sid -
1 Nov 2006 10:08 PM - 5 messages
We have a SQL 2k server and we are trying change the file size to increase its self by Mbytes as opposed to percent. But the setting won't stick. You can select it, "OK" close the config manager and open it back up and its set back to "Percent". ...
Why SQL server lost its performance?
Mike Torry -
1 Nov 2006 9:56 PM - 2 messages
I brought this question in other group but without the clue by far. I have SQL Server 2000 on my WIN 2000 server. Normally SQL server run smoothly. But as soon as I start MSSQLServerOLAPService on my server, msmdsrv.exe will run and it will use large amount memory and CUP. Then my ...
Training courses for 2005 Analysis Services
nupee -
1 Nov 2006 9:29 PM - 2 messages
Hello, Would anyone have any ideas or suggestions as to where in New York City, we can take training courses for Analysis Services 2005 version. These classes can be for beginner all the way to Advanced. Thank You!! ...
ms sql data tool
mecn -
1 Nov 2006 8:39 PM - 6 messages
hi, Anyone knows what ms sqlem - data tools is in trace file i caught, appliactionName field Thanks, ...
Error 1205 is missing
Lynn -
1 Nov 2006 8:26 PM - 15 messages
please let me know what you think, this is very, very important. i am plagued with a nasty little intermittent deadlock problem, and am in the middle of trying to correct it. i've received from help from a sql peer who ...
Simple (begnner) admin question...
skull_leader7 -
1 Nov 2006 6:16 PM - 4 messages
Is it required for the dbo user in a database to be mapped to a given login for that login to be able to access objects owned by dbo without explicitly specifying this (i.e. select * from mytable rather than ...
Installing Multiple Instances Design Question
Hulicat -
1 Nov 2006 5:57 PM - 3 messages
I have 4 small small SQL 2000 databases that I need to consolidate to a single machine. The data is minimal maybe 100 GB total with an expection of some moderate growth. The box will be configured with a raid 5. ...
Log file won't shrink
Michael MacGregor -
1 Nov 2006 5:36 PM - 8 messages
We're having a problem with one log file which refuses to be shrunk. First off we have a problem with the fact that the log keeps growing way too much, something that I have to look into, but besides that, I've tried to ...
Receive E-Mail Using Database Mail?
chfran -
1 Nov 2006 5:27 PM - 4 messages
I would like to use database mail to receive e-mail and do something with an attachment. Is that possible? If so, any suggestions or guidelines to follow? ...
XP_Sqlmaint to TSql commands
BH337 -
1 Nov 2006 5:11 PM - 5 messages
Hello all, I want to translate my SQL 2000 Maintenance Plans into TSQL jobs. The reason for this is that I want to have these jobs run dependent on one another so there is no overlap in tasks. For example, I wan to run ...
sp_executesql
Erencan SAÐIROÐLU -
1 Nov 2006 5:07 PM - 5 messages
Hi To All, I have a question. I execute two query in seperate times with sp_executesql. The first query executes with parameters, the second quert executes without parameters. In normally the first query (With parameter) has to execute too fast than ...
clean server cache
mecn -
1 Nov 2006 5:03 PM - 5 messages
Hi, I am testing .net app. I restored sql server databases with overwrite the original database. I re-launch the .net app, I got this error says. Could not connect to the database DBID = 15.... After I reboot the sql server, I was able to connect again,. ...
default SSIS package location
thejamie -
1 Nov 2006 4:53 PM - 3 messages
After creating a complex SSIS package, I am unable to locate it. My guess is that it is located in a default location. Where is that? ...
Database Mail definition - confusing
tootsuite -
1 Nov 2006 4:52 PM - 2 messages
Hello, For improved security, Database Mail manages access to mail profiles. A profile may be public or private. Public profiles are available for all members of the DatabaseMailUserRole database role in the msdb database. They allow all members of the DatabaseMailUserRole role to send e-mail ...
How to shrink a SQL Server 7 device
Ryan Gaudet -
1 Nov 2006 3:39 PM - 2 messages
Hi, I have a seven year old SQL Server that has a 10GB Data Partition. Our main DB is only around 6.5 GB but for some reason, the device size is almost 9GB. The transaction log also has a lot of free space but but it is pretty small ...
Instance/sqlservr.exe problem
toma -
1 Nov 2006 3:37 PM - 4 messages
Hi! I have SQL 2000 server with several instance. Every instance start own sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100% CPU time, but I don't know to which instance it belongs? regards, Toma ...
Help with long running Update query
ian.wrigglesworth -
1 Nov 2006 2:49 PM - 4 messages
Hi i was wondering if anyone could help with the following query. Sometimes it takes 11 mins to run, sometimes it takes around 5 hours and the it seems random as to when it happens. Each table has around 1.4 million rows in and i have included a copy of ...
SSIS - FTP Tasks
Kar Rao -
1 Nov 2006 2:40 PM - 3 messages
Hi: The standard FTP Task only allows saving to a local folder. Is there any way I could save downloaded file to a table directly without first saving to Folder and then using FileSystem? TIA Kar ...
SSIS - Package Deployment Security
Kar Rao -
1 Nov 2006 2:19 PM - 2 messages
Hi: Would like to secure my packages and use them in licensed applications such that: a. Users cannot see whats in the package b. Users can run the package c. I should be able to offer multiple licensing modes (like Node, CPU) ...
q; how to write this trigger
JIM.H. -
1 Nov 2006 2:09 PM - 2 messages
I have table T1 with the fields: ID,Type,Status,F1,F2,F3,F4 in database1. I also have T2 in Database2 which has the same fields and some extra fields. Now based on the T1.Type=Insert or Update, I need to perform either update ...
Drawbacks of putting transaction log on system drive
Oskar -
1 Nov 2006 1:39 PM - 2 messages
Hi, I use MS SQL Server 2000 SP3a on MS Windows 2000 Advanced Server (latest). Would I come across any drawbacks if I put all transaction log files of a database onto the system (OS installation) drive along with a page file and ...
Get script filename within SQL script
JJ Williams -
1 Nov 2006 12:30 PM - 8 messages
Hi, SQL Server 2000. How do I get the filename of the script currently being executed from within the .SQL script itself? Is there a special variable containing the filename of the .SQL script, or another method of obtaining it? ...
TDS_RET_STATUS error
jack.smith.sam -
1 Nov 2006 11:35 AM - 4 messages
Hi, I wrote a Java program which connects to SQL Serve 2005 and used prepared statements. I got the following error: com.microsoft.sqlserver.jdbc.SQLServerException: No TDS_RET_STATUS was found for the stored procedure output parameters. Do you have any idea? ...
Cannot start sql agent in 2005
Blakmk -
1 Nov 2006 11:11 AM - 2 messages
I get this message when I try to start a sql 2005 server agent. Im running windows 2003 service pack 1 and sql 2005 service pack 1. The strange thing is the agent and sql service are running as a domain ...
RESTORE sqlserver2005DB to sqlserver2000
Mukut -
1 Nov 2006 10:48 AM - 4 messages
Hi all, Does the compatibility level of sqlserver2005 affects the transfering of the 2005DB to sqlserver2000? Our 2005 database has a compatibility level 80.And our sqlserver2000 has the same compatibility level.While transfering database(from2005 to 2000), do we need to handle this compatibility? ...
What is the significance of ";" in sql statements
Newish -
1 Nov 2006 9:43 AM - 3 messages
Hi A very basic question. What does semi colon mean when used in sql statements. thanks Newish ...
Derived Column
MilkBottle -
1 Nov 2006 9:15 AM - 4 messages
How do i change the data type of a column using the derived column feature? I have two columns that need changing (a) needs to be changed to an integer (b) needs to be changed to a date Both columns contain balnks and spaces! ...
Please Help! Detach database
Pola -
1 Nov 2006 8:56 AM - 6 messages
Hello, We have to do detach database. We can't do detach when another applications connected to database. 1. How we can know number of connected aplications to this database? 2. How we can disconnect this applications in order to do detach for database? ...
Data Dictionary project
Matt -
1 Nov 2006 6:39 AM - 3 messages
We have several databases on SQL 2005 which were built seperately. Ive been asked to come up with a plan for making sure that data elements are consistent across all of them, and conform to an outside standard definition which I have a document for. Ive also been asked to make it ...
SQL SERVER2005 ->SQL SERVER 2000
Mukut -
1 Nov 2006 4:53 AM - 8 messages
Hi all, We have a requirement in our project to restore the backup of sqlserver2005 database in the sqlserver2000.Our onsite database is in 2005 and offshore database in 2000. While doing, we got an error saying Error 3169:The backed-up database has on-disk structure version ...
FoxPro vs. SQL
Alex S -
1 Nov 2006 12:11 AM - 14 messages
Hello everyone, My company uses a FoxPro database right now as an interface and a database. For our situation, I have come to the conclusion that it would be a better choice for us to move to an SQL server of some ...
Issue with incorrect metadata ?
Tim Greenwood -
31 Oct 2006 10:26 PM - 7 messages
We're running SQL2k5 and I've got some stored procedures which all have the last parameter as optional with a default value of zero i.e. create procedure myproc @Parm1 int, @Parm2 int=0 ...
Error: 7105, Severity: 22, State: 6
ME -
31 Oct 2006 10:24 PM - 3 messages
My SQL server logs this in Application log: Error: 7105, Severity: 22, State: 6 Page (1:952446), slot 39 for text, ntext, or image node does not exist. MS KB890755 [link] asked to contact MPSS for ...
Re-start database?
Olav -
31 Oct 2006 9:27 PM - 11 messages
I have done the following on a running database: ALTER DATABASE Test MODIFY FILE ( NAME = Test_log, FILENAME = 'F:\Microsoft SQL Server\Data\Test.ldf' ) This resulted in this message: The file "Test_log" has been modified in the system catalog. The new path ...
|
|||||||||||||||||||||||