|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
Linked server help: MAS90 URGENT!
Craig Lucas -
22 Apr 2006 11:58 PM - 2 messages
Has anyone successfully created a linked server to a MAS90 database? I have tried creating a UDL file and copying the connection string into the linked server area, but Im running into errors when trying to access anything in the database. I have also tried using OPENQUERY with the same connection ...
Triggers...and updates
Bob Bartel -
22 Apr 2006 8:52 PM - 6 messages
I have a last_update field in my table, its a datetime field. I need to create a trigger so that everytime the record is edited the last_update field is updated to the current date/time. How can I write a trigger so ...
General network error. Check your network documentation - ADO.Net
RJN -
22 Apr 2006 1:32 PM - 3 messages
Hi I'm getting the General Network error, though not consistently. Stack trace is below. Any fix for this? at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, TdsParserState state) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, TdsParserState state) ...
SQL 2005 trial software
Dabbler -
22 Apr 2006 1:14 PM - 2 messages
Does the 180 day trial software still function for developers as a single connection server after the trial expires? I have Express installed locally for test but I'm actually interested the Enterprise Manager component to administer remote SQL server databases for my ...
Windows 2k crash in schedule MS SQL backup
Pete Mares -
22 Apr 2006 12:48 PM - 3 messages
Hi, I have a problem on one of our servers. Windows 2k server with SP4 crash every 6th day during regular, scheduled backup of SQL db. When I analyze the memory dump I get following result Probably caused by : ntkrnlmp.exe ...
SQL Server User
Rajani -
22 Apr 2006 10:22 AM - 2 messages
Hello friends, I just installed SQL Server 2000 standard edition in Win 2000 server. The authentication mode is(windows NT authentication) so that it will take windows user and password. But i want to specifiy some user and password to ...
SQL server native backup files..
Hassan -
22 Apr 2006 7:23 AM - 2 messages
Are they Ascii or binary type ? ...
ftp command help
Hassan -
22 Apr 2006 7:19 AM - 2 messages
I need to schedule copying of files to an ftp share using a SQL agent job..but i dont know how to do that in one step Say for eg: the source of files are on \\computerA\share1\*.* and the destination is an ftp site ftp.x.com with a username and password ...
SQL Server 2005 sp1 changes
TomT -
22 Apr 2006 5:45 AM - 3 messages
Can anyone point me somewhere to find out what, other than issues covered in KB's, has changed with this service pack? E.g., Management Studio is updated, but I'm not sure in what way, etc. I've searched around but have not been able to find anything other than kb's ...
URGENT : How to move databases in SQL server CTP to SQL server 200
Roshan Jayalath -
22 Apr 2006 4:58 AM - 2 messages
Hi All, Can someone tell me the easiest way to move databases which are in SQL server 2005 CTP into SQL server 2005 enterprise edition please ? This is a bit urgent for me ! Best Regards, Roshan ...
Ntwdblib.dll client/server versions need to be the same?
donsql22222 -
21 Apr 2006 11:15 PM - 2 messages
My book says that Ntwdblib.dll must be the same on both the client and server...BUT, it also says that the server version must "support" the client version. Question: If the server version is the latest, will it "support" all the ...
Help!
Terry -
21 Apr 2006 9:38 PM - 3 messages
Hello, I am trying to copy user logins from one database to another on the same instance of SQL. I used DTS to export the data to the new database, when I should have used the backup option. I'm in a bet of trouble. Now the users can not access the copied database. ...
Relational Desing Question
dubian -
21 Apr 2006 9:26 PM - 6 messages
I am trying to desing a set of tables but I have come up against a normalization problem and could use a spot of help. Here is what I want to acheive - TableDevices ------------------------------- DeviceId (PK), DeviceType TableDeviceTypeADetails ---------------------------------------- DeviceId (PK), details columns...... ...
Link tables
EESP -
21 Apr 2006 9:04 PM - 3 messages
Is there a way to incorporate link tables in SQL Server similar, if not the same way Access ineracts with them? ...
SQL2005 SP1 issue?
Autox -
21 Apr 2006 8:24 PM - 19 messages
Has anyone applied SP1 to their SQL2005 server? I did this and Integration services will no longer start. I just get an error about not starting in a timely manner. I deinstalled Integration services and then reinstalled them. The service started but as soon as I ...
Copy row
David -
21 Apr 2006 7:54 PM - 2 messages
I am trying to copy a row and then update only a couple of fields. Is there not an easy comand that allows one to do this. Otherwise I have to list all the fields in the insert function just to change two ...
Query running taking to long on one server compared to another
cfrank -
21 Apr 2006 7:31 PM - 2 messages
I am running SQL Server 2000 sp4 on Windows 2003 64 bit version. I have two servers that are identical Development and QA. I have a fairly small query maybe 5 joins in it. It runs in 2 minutes 10 ...
How Do I Get SQL Server 2000 Reboot Time
BillJohnson4 -
21 Apr 2006 6:13 PM - 5 messages
I'd like to report to the user when the server was most recently rebooted. Is there a stored procedure or SQL Server 2000 command that I can issue? ...
Restoring from an copy of the offline database?
Randy K -
21 Apr 2006 6:00 PM - 5 messages
I have a question considering restores. If I take my database offline the backup system will backup the .mdf and .ldf files making up the database. Can these files be used to restore a SQL 2000 database. The reason I ask is that we don't have enough space to create a full ...
How can I determine how values will sort based on the Order By clause?
Rob Kraft -
21 Apr 2006 3:56 PM - 3 messages
I have a table full of values that I sort. I want to add some new values, but have them sort to the bottom. I thought, that if I put an underscore, or a pipe, or a tilde at the front of my data, I could make it sort last. ...
Copy users between databases
Terry -
21 Apr 2006 3:37 PM - 2 messages
Hello All, I used DTS to copy one database to a blank database for a backup of the database. A duplicate database. How do I copy over the user logins to the new database. This did not happen with DTS. ...
the seed value, how do i change it
jvcoach23 -
21 Apr 2006 2:39 PM - 3 messages
I'm trying to take an exising identity column and chagne the starting seed value. What i had was a database I was doing testing in. I'm ready to roll it to production.. so i'm cleaning out the test data and want to reset the ...
MSX server in SQL 2005
Woo -
21 Apr 2006 1:39 PM - 4 messages
I currently have a master server in SQL2000 and I have now have a couple of new SQL2005 installs on different servers. I wish to make these new servers target servers. So my question is - can a Master SQL2000 sever, target a ...
Running Oracle and SQL in a single server
Saravanan K -
21 Apr 2006 12:03 PM - 3 messages
Hi, anyone there to let me know if i can run both Oracle and SQL server 2000 in a single high end server? ...
Backup on 2005 and restore on 2000
Mads.phi -
21 Apr 2006 11:48 AM - 2 messages
Aloha, I know this question have been asked before and that it's not possible to move backups from 2005 to 2000 :( It's easy to transfer to structure of the database using the scripting option in SQL 2005, but I have some problems with the data. ...
SSIS dead after 2005 SP1 upgrade
Pat -
21 Apr 2006 11:22 AM - 6 messages
The 2005 SP1 upgrade went fine, except for SSIS where I got a "failure", without further explanation from the install programm. Now the SSIS service refuses to start. I get "The request failed or the service didn't respond in a timely fashion. Consult the event log or other ...
Performance of dual core v/s large cache Xeon processors
Sparky -
21 Apr 2006 10:40 AM - 5 messages
Hi, I am in the process of procuring new quad CPU server hardware to run MS SQL 2000 server. I expect the server to be very heavily loaded. In this regard I would like to know if someone has done performance ...
security for row level but not based on Database user's login
Friends -
21 Apr 2006 10:29 AM - 2 messages
Hi I need to set security for row level but not based on Database user's login. It should be based on the user table login. For the particular user I need to allow only the particular records to access insert, ...
Simple backup solution
JSL -
21 Apr 2006 10:01 AM - 8 messages
Hi. This is a small shop with one critical app/database on SQL2000. It is now backuped regularly w. Backup Exec to tape (database) and disk (log files). I have another server installed with SQL2000 which I plan to use as a poor ...
BSOD blamed on nlemsql.sys
Rik Hemsley -
21 Apr 2006 9:12 AM - 2 messages
We have Server 2003 crashing every day or so, saying: *** STOP: 0x0000008E 0xC00000005,0xF74FB472,0xB8681AEC,0x00000000 *** nlemsql.sys - Address F74FB472 base at F74F7000, DateStamp 3eca40a0 There are only two references to nlemsql on Google, neither of which are related to a crash. ...
Stalled connections to the database
Meenal Dhody -
21 Apr 2006 8:26 AM - 4 messages
Lately I have noticed that an sp that may take 5-10 minutes to execute ordinarily (it is a batch process) will start and then just hang and not complete. After about 45 minutes if the application calling that process is stopped ...
SQL Express and sa password
Lonifasiko -
21 Apr 2006 7:57 AM - 4 messages
Does SQL Server Express edition installation (included by default in Visual Studio 2005 installation) ask for a password for 'sa' user? In my case I believe no. I'm able to connect using Windows authentication to Express instance, but I cannot do it with 'sa' user. I've tried blank password but no ...
SQLServer 2005 Database corruption caused by rollback in some trig
sadietz -
21 Apr 2006 5:49 AM - 3 messages
In SQL Server 2005 (with or without SP 1), a rollback in some table triggers can cause database corruption. This error does not occur on SQL Server 2000. An error like the following (with Event ID 3315) shows up in the Event Viewer: ...
[TCP/IP sockets]sql server does not exist or access denied
Wen Chang -
21 Apr 2006 2:16 AM - 2 messages
I reinstalled sql server 2000 on Windoes server 2003 three times due to diff errors - 1st time replication recovery did not work; 2nd time typo in the file name ; 3rd time typo in the server name. Then when I installed it the ...
automatically recompile views & functions
rmandel -
20 Apr 2006 11:40 PM - 2 messages
Is there a way to automatically recompile? ...
Checking Database Recovery Mode
Rosie -
20 Apr 2006 10:46 PM - 4 messages
Hi, How can I find out what the current recovery mode of a database is? I know that I can set it with ALTER DATABASE command but I don't know how to check to see what the current mode is. Could you please someone help me? ...
Differential Restore
Timart -
20 Apr 2006 10:41 PM - 3 messages
Win2K3 SQL2K Enterprise Edition This is my current backup schedule Sunday FULL M-Sat Differential TranLogs Backups every hour I am trying to restore to a point in time, specifically to the time right after my last Differentail backup. I am using Ent Manager for ...
Ntwdblib.dll newest version?
donsql22222 -
20 Apr 2006 10:14 PM - 4 messages
How do I install the latest DB-Library? I think this is Client Tools, but I can't figure out if this is on the SQL 2000 install CD? This will be on a server that does not have SQL on it, but connects to a SQL ...
SAN snapshots and SQL database
Sas -
20 Apr 2006 9:25 PM - 3 messages
Hello Everyone, Can someone tell me if there is a vendor that has the option of making a snapshot of a drive or vdisk with a SQL Server database? As far as I understand, a normal snapshot might not have a consistant copy of the ...
No Transaction Log Backup after installing SP1
Sorcerer -
20 Apr 2006 8:42 PM - 4 messages
Hello, after installing SP1 for SQL Server 2005 the sql agent cant execute the existing management job to backup the transaction log. even if the job is created new by deleting it in the maintanance plans and recreate it the sql ...
0xFFFFFFFF Value in Column
snook -
20 Apr 2006 8:38 PM - 2 messages
Hi, I have adopted a DB and I am having issue with a binary column that returns values of 0xFFFFFFFF. I am trying to translate this value into something meaningful but I am having no luck. Any ideas are much ...
SQL 2005 Service Pack 1 Failure Log
vbnetdev -
20 Apr 2006 8:01 PM - 8 messages
Fails at "Unable to install Windows Installer MSP file". Log is below. Can anyone help? It fails in the GUI over "Setup Support Files" 04/20/2006 15:00:18.093 ================================================================================ 04/20/2006 15:00:18.109 Hotfix package launched ...
SSMS - Registered Servers
KLC -
20 Apr 2006 8:00 PM - 2 messages
In SSMS Registed Servers 2/3 of the 100+ sql servers in my network do not show up with the "green light" for status. They all display correctly in Enterprise Manager. What gives? ...
Moving a Database
Johnfli -
20 Apr 2006 7:41 PM - 6 messages
I have a few databases that is clogging up my C drive and I would like to move them to my D: drive. What is the easiest and safest way to do that? ...
how to copy only the stored procedures to another server/database
Carlos -
20 Apr 2006 7:10 PM - 2 messages
Hi all, I am just getting my feet wet with SQL server, and need to only copy the stored procedures from one db to another. I tried the export tool, but even though it allows me to select the objects I want, it ...
Indexed View Vs. Table
alim -
20 Apr 2006 6:58 PM - 5 messages
Would anyone tell me what is the advantages choosing indexed views over tables? As far as the spacing is concern, both the indexed view and the table take space. Then, why shouldn't I create a table with the sub-set of data ...
SQL 2000: BCP and text columns
Maxwell2006 -
20 Apr 2006 6:28 PM - 3 messages
Hi, I have a very big table with 5 text columns that contain very large amount of text data. I need to transfer this table to another platform. What would be the best BCP settings to export this table into a file? ...
problem with SQL Agent
kjoyner -
20 Apr 2006 6:16 PM - 3 messages
OK this is a new error on me. I have a SQL server 2000 on Windows Server 2003. I have setup a Maint plan that backs up the user and system databases and the transaction Logs on my user databases. ...
SQL Server DB Engine on Enterprise Edition
weegee -
20 Apr 2006 4:35 PM - 2 messages
Hi there Forgive me for the newbie nature of this question. I had SQL Server 2000 on my machine and I have just installed SQL Server 2005 Enterprise Edition. It installed the SQL Management Studio, Configuration Tools, Managment Services...but I was looking for the equivalent of: ...
Parallelism - Standard vs Enterprise Edition
Terry -
20 Apr 2006 3:59 PM - 2 messages
We were told by a Microsoft representative that Intraquery Parallelism is available only in the Enterprise Edition of SQL 2005. Can anyone confirm deny that and support with documentation? Standard fits our needs all other features, but I don't want to lose ...
Linked servers
Vik -
20 Apr 2006 3:21 PM - 2 messages
I can create the views in an SQL server based on the tables/views in a linked server. I can retrieve data using these views. But I cannot save them. The server freeses when I try to save these views. What may be wrong ...
Licence's
Phil -
20 Apr 2006 2:47 PM - 2 messages
Hi All, I was wondering if someone can help me out with some information, I have inherited a SQL Server System running 2000 but nobody seems to have any Licence information for it, I have been assured that is has been registered ...
SQL Server version on remote machine
Grubs -
20 Apr 2006 2:11 PM - 4 messages
Hi How can I look up the SQL Server version (e.g. 2005, 2000, 7.0, etc) on a remote server? Obviously on a local machine @@VERSION or the SERVERPROPERTY function provide this information. What I require is a way of obtaining this information from ...
Profiler Trace Analysis
neeju -
20 Apr 2006 1:32 PM - 2 messages
Hi All, I have recieved some 50 trace files (.trc) from the client and they want me to analyze them all in 1 hour and let them know certain things. I have heard there is some way to analyze all the files simultaneously ...
What's this table for in my database?
Fred Flintstone -
20 Apr 2006 1:23 PM - 3 messages
I ran a DBCC CHECKDB on one of our databases. It contains many tables but also this: There are 1 rows in 1 pages for object 'Surveys57'. DBCC results for '~TMPCLP381551'. There are 146389 rows in 146389 pages for object '~TMPCLP381551'. ...
SQL2005 SP1 install problem
Peter Lawton -
20 Apr 2006 10:29 AM - 25 messages
Anyone else having trouble installing SQL2005 SP1? Everything patches OK except "Database Services", I get an error Hotfix.exe has encountered a problem and has to close Peter Lawton ...
URGENT: no management studio
Freddie -
20 Apr 2006 8:57 AM - 8 messages
Hi, I`ve insalled VS 2005 Team System first and then SQL Server 2005 developer edition on Win 2k Pro SP4, and now cant find ANY management tools for the SQL(and i checked everything in the install app). And onether question: do I have to check for @@Error in my SQL 2K ...
groug query
Yousuf -
20 Apr 2006 6:28 AM - 9 messages
I m having 2 details table as purdtl and saledtl i wanted to write a query by joining both details tables purdtl table is having fields like itemcode, batchno,qty,purno,rate,vatrate,vatamt saledtl is having fields like itemcode, batchno,qty,saleno,irqty ...
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection
khokimfang -
20 Apr 2006 4:39 AM - 3 messages
Hi All, I have a problem. The problem is i have 2 server database and i want to linked them. Server 1 is A with spesification Windows XP and SQL Server 2000 Developers. Server 2 is B also as Domain Server, with spesification ...
Disconnected application and replication
John -
20 Apr 2006 3:56 AM - 5 messages
Hi We have a situation where the sql server backend is on the server but several laptop users need to disconnect and still be able to use the data. Can we have copies of say sql express on each laptop which can replicate ...
DTS job not executing all tasks
Jeff User -
20 Apr 2006 2:38 AM - 3 messages
SQL Server 2000 I created DTS package with several step. When I run manually, all steps work OK. When I schedule as job, only the first step runs. The next two steps do not run. The log simply says step ...xyz.. did not run ...
HOWTO: Create a new server (instance) in SQLEXPRESS
Sam Malone -
20 Apr 2006 1:01 AM - 6 messages
Try as I may, I haven't figued out how to create a new server instance in SQL Express. Any suggestions? Pointers to documentation? A psychic? A magician? Whatever will work. Many thanks. ...
sp_help_revlogin
silversov -
20 Apr 2006 12:10 AM - 3 messages
Hi all, I noticed today that the sp_help_revlogin stored procedure has changed significantly from the original one I downloaded. As a result it no longer appears to compile with an error "loginproperty is not a recognised function" on SQL 2000 SP3a. ...
JOIN Clause over UNION
cbrichards via SQLMonster.com -
19 Apr 2006 11:13 PM - 4 messages
I have read where a performance gain can be achieved by using a JOIN claus over UNION. I have attempted to replace the UNION in the following statement (labeled ORIGINAL), by using OR (in the statement labeled MY ATTEMPT) but to ...
Deletetion of an old Remote Server
Rob -
19 Apr 2006 9:29 PM - 3 messages
I am trying to set up a publisher and I get an Error 18482: Could not connect to server 'servername' because 'WEB1' is not defined as a remote server. I went to the Remote Servers where WEB1' is listed, although this ...
transaction log and column modifications
Bruce Hendry -
19 Apr 2006 9:25 PM - 7 messages
I'm at a loss as to how to figure this one out. The identity column for a production table was mysteriously decremented by 2. I became aware of this when a program that loads data into this table suddenly errored out due to a primary key violation. ...
SQL Server 2005 Books Online April 2006?
Olav -
19 Apr 2006 8:36 PM - 4 messages
Where can I find the April 2006 version of SQL Server 2005 Books Online to download? Olav ...
Referential Integrity practices for complex Database
bluefish -
19 Apr 2006 8:31 PM - 3 messages
I am a database Engineer for a company that has relatively large and complex SQL Server databases. The DB Engineers group seem to have different opinions about weather or not we should enforce referential integrity to our database.(In fact we have ...
What's the best way to keep a live db and an archive db?
0to60 -
19 Apr 2006 8:03 PM - 8 messages
I have a live, production db that I'd like to keep lean and mean for performance reasons. Every so often, I'll run a cleanup script to scrub out some older data in order to keep the tables from growing indefinitely and ...
i can use SQL2005 Client Tools with SQL2000?
Tark Siala -
19 Apr 2006 7:59 PM - 5 messages
hi i can use SQL2005 Client Tools (lik vs2005) with SQL2000, to control and run SQL Statement? ...
How to open and read from transaction log backup
ktf -
19 Apr 2006 7:29 PM - 4 messages
Is there a tool I can use to open and read transactions from the transaction log back up? How do I do that? Thank you, ktf ...
SQL 6.5 syntax help pls
Joe D -
19 Apr 2006 6:56 PM - 5 messages
I have a SQL 2000 instance where a vendor database's database compatibility level is set to 65. I need to drop a column from one of the tables. The SQL 2000 syntax of 'Alter table MyTable drop column OldColumn' isn't working. I ...
First SQL2K5 server install performance issues
Tim Greenwood -
19 Apr 2006 6:45 PM - 4 messages
This is comparing performance between two machines....the first is our current SQL2000 server Dual 3Ghz Xeons on dual channel scsi drives. New machine Dual 3.6Ghz 64-bit Xeons dual channel scsi SCSI controller in each box is identical as is the drive configuration and ...
SQL2K Maint. Plan Error
Steve -
19 Apr 2006 6:29 PM - 3 messages
Hi all; I have a maint. plan on both SQL 7.0 and SQL 2K. Both plans are setup the same. However on the SQL2K plan I keep getting the "Single User Mode" err written to my log. ...
syntax to turncate transaction log ...
Me -
19 Apr 2006 6:05 PM - 4 messages
Can someone please send me the syntax to truncate transaction log, one by iteself and the second one with check option. Is it safe to use the truncate transaction log option and how should I execute it? Thank you very much for your help! ...
memory used by sqlservr
Zen -
19 Apr 2006 5:45 PM - 2 messages
Hi, My sql server is running on a Windows 2000 server with 2G physical memory machine and I'm looking at the private-bytes performance counter for sqlservr process and it's taking 1.8G. Is that something I should be ...
sql 7, access97, and a switchboard
BrianMultilLanguage -
19 Apr 2006 5:20 PM - 2 messages
We were running sql 7sp4 with users running access97. The users were running a copy of the switchboard locally. We up'd the sql to 2000. Now, Can I up access to (2000,2002,or 2003) to run the switchboard>? ...
SS2005 Performance Isues
Jack -
19 Apr 2006 5:04 PM - 5 messages
I've got a stored procuedure that sometimes take milliseconds to run and other times take 40+ seconds passing in the same parameter values. Any ideas where to look? We had the database on 2000 and never had any problems. Since taking it to ...
Uninstall SQL Server 2005 Standard Edition
irmaNugroho -
19 Apr 2006 4:40 PM - 3 messages
Hi there, I would like to uninstall SQL Server 2005 Standard Edition but could not find any instructions on how to do it. Searching on Google gave me results on how to uninstall the beta or CTP versions but not the ...
Robust Plan
Hess -
19 Apr 2006 4:30 PM - 2 messages
Folks, I am getting the follwoing error: "cannot sort a row of size 8192, which is greater than the allowable maximum of 8094" . Doing the research around the web, I found a solution which had be using Option "Robust Plan" as a part of the query. ...
Current Database ID/Name
Shan -
19 Apr 2006 4:09 PM - 2 messages
Hi, How could I find the Current database name when I am Query Analyzer. Is there any function like @@Servername. ...
SQL Server 2005 Upgrade: Need to Install Client?
q_test -
19 Apr 2006 3:21 PM - 2 messages
I am upgrading SQL Server 2000 to SQL Server 2005. Some databases are Web Applications; some are client-server applications. Questions: What do I need to install on Web Server? And Client machines as well? It seems that the client server application connected through ODBC is ...
Excel Output
Jim Heavey -
19 Apr 2006 3:16 PM - 2 messages
I want to run a stored procedure which will run a specific query and put out a monthly file each month. The name of the file with be "jan.xls" for Jan data and then the next month it will be "feb.xls" for Feb. In addition, I ...
Q: write this query
JIM.H. -
19 Apr 2006 3:15 PM - 2 messages
Hello, I have table T1 and F1, F2, F3, F4 and F5, and a Count field Now I need to write a query that groups by fields and returns sum of count for each field such as F1, Sum(Count)ForF1,F2, Sum(Count)ForF2, …F5, Sum(Count)ForF5 ...
Server Consolodation
Carl Hilton -
19 Apr 2006 2:35 PM - 5 messages
OK, I am changing my infrastructure and my question is... Should I consolidate all my small SQL servers into one (SMS, WSUS, SurfControl, McAfee ePO) Currently they are all stand alone servers running MSSQL or MSDE, and will be migrated to a SANS. ...
Efficient SQL Backup?
bajaj.vishal -
19 Apr 2006 2:23 PM - 2 messages
Hi all, I am having issues of efficiency of backing up data from one SQL data base to another. The two servers in questions are on different networks , behind different firewalls. We have MS SQL 2000. On the source data i run a job with the following steps: ...
Starting a SQL Job Remotely
D Johnson -
19 Apr 2006 11:36 AM - 6 messages
Is there a standard method for starting a job remotely. SQL Server A needs to start a job on SQL Server B. Thanks David ...
Can timestamp columns be updated?
Oskar -
19 Apr 2006 11:25 AM - 6 messages
Hi, Is there any way timestamp columns can be updated in Microsoft SQL Server 2000 (SP3)? -- Many thanks, Oskar ...
Problem with collation
Jesus Suarez -
19 Apr 2006 10:30 AM - 14 messages
hello, I have a problem with collation sql server, my collation is moderm_spanish. I have to send a mail, this mail is stored in the Database, when i receive this mail in my mail client, the characters "ñ" is not interpreted by this ...
Defrag Script
BenUK -
19 Apr 2006 10:20 AM - 4 messages
Hi all, I'm writing my own defrag script. I've set it up so under certain conditions it will run an IndexDefrag and under others a Reindex. I wanted to post the conditions I've set and see if anyone has any feedback that can improve them. ...
SQL Agent: Startup error: Unable to initialize error reporting sys
Beverley -
19 Apr 2006 9:29 AM - 4 messages
I'm trying to start the Agent and keep getting the following error. 2006-04-19 09:29:00 - ! [241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started) 2006-04-19 09:29:00 - ? [098] SQLServerAgent terminated (normally) ...
Login question
sloppycode -
19 Apr 2006 9:04 AM - 2 messages
I have a login that I need to use across multiple servers in a thin client application. It's for internal use so one login will suffice. I initially thought I could just make a login on our domain and then add ...
How to put a matrix-like structure in a database?
Pieter Coucke -
19 Apr 2006 8:16 AM - 4 messages
Hi, In the factorys of my company, people have to do a whole bunch of measures (temperatures, sizes, pressures, ...) on a daily or weekly bases. These measures should be encoded, and be visible in reports (Reporting Services). Every measure has a maximum and minimum value, and if the measure isn't ...
Define relationships on remote MS SQL server 2000?
Noozer -
19 Apr 2006 8:05 AM - 2 messages
Using Microsofts SQL Server Management Studio Express, is it possible to define relationships between tables? My database is hosted by my domain hosting company. I can connect to their server and modify my tables without an issue, but I can't see how to relate ...
Copy database from remote server to local?
Noozer -
19 Apr 2006 8:02 AM - 5 messages
My domain host hosts my MS SQL 2000 database. I am able to connect to it from my workstation using the MS SQL Server Management Studio Express application. I want to copy from the remote server, modify it, and upload it ...
SQL server agent stops running after some days despite restart settings
google -
19 Apr 2006 7:06 AM - 4 messages
Hi all, I have an SQL server 2000 on Windows 2003 server SP1, and everything works fine. There are a number of maintenance tasks that are scheduled by the SQL server agent, some run every ten minutes, others every day, ...
Log shipping and database snapshots
Kevin Jackson -
19 Apr 2006 6:26 AM - 3 messages
SQL Server 2005 Can a database snapshot be created on a log ship target standby database so that read-only reports and/or datamarts be ran???? I know this is fully supported when using Database Mirroring but Microsoft isn't supporting this ...
Memory allocation for complex cluster setup
Dan Banick -
19 Apr 2006 5:26 AM - 2 messages
Greetings. Having some difficulty consolidating on the appropriate memory setup for the following configuration: 2 node cluster, Windows 2003 Enterprise Edition SP1 with SQL 2000 Enterprise Edition SP4. There are 6 virtual SQL servers installed. Generally we run ...
How to Schedule Backup for SQL Server 2005 Express
wrytat -
19 Apr 2006 5:07 AM - 13 messages
How do you schedule to backup database in SQL Server 2005 Express? I tried following the steps mentioned at [link], but there are errors . Firstly at command prompt when I execute OSQL -Usa -PmyPasword -i ...
|
|||||||||||||||||||||||