|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Microsoft SQL Server Administrationmicrosoft.public.sqlserver.server
SQL Server 2005 installation?
Erland -
23 Sep 2006 7:06 AM - 3 messages
Hello all, I am new to installing Visual Studio 2005 and SQL Server 2005. I have just installed a visual studio 2005 professional edition on my Windows XP-Home SP 2 box. I suppose, SQL Server 2005 was installed with VS 2005 ...
sql server 2005 upgrading
Dodo Lurker -
23 Sep 2006 4:19 AM - 4 messages
I am planning to upgrade my production database to sql server 2005 (it's currently a sql server 2000 machine at service pack 4). What's the best approach to do this? Should I try to upgrade it directly ...
dbcc dbreindex and update of statistics
Dodo Lurker -
23 Sep 2006 4:13 AM - 4 messages
I have to set up a nightly job on my database to drop and reindex indexes on my tables. I am going to use dbcc dbreindex. Does the dbcc dbreindex also update the statistics on the rebuilt index or do I have to then issue ...
Error: 17053, Severity: 16, State: 1. Exception 0xAE
Bryan Aldrich -
23 Sep 2006 1:16 AM - 6 messages
I have recieved billions of: 2006-09-22 02:07:06.76 spid11s Error: 17053, Severity: 16, State: 1. 2006-09-22 02:07:06.76 spid11s High priority system task thread: ...
WITH NOLOCK and ROWLOCK
mpaine -
23 Sep 2006 12:12 AM - 3 messages
I am a bit confused as how WITH (NOLOCK) and WITH (ROWLOCK) work. Is it ok to use these statements often if I never use BEGIN TRANSACTION, COMMIT TRANSACTION or other transaction related statements? Or, if those are used, make sure they are unrelated to the same tables and ...
Linked Server Alias?
Dave -
22 Sep 2006 9:55 PM - 2 messages
Is it possible to create an alias for a linked server? For instance when I reference a linked server today I have to specify server.database.schema.table. I would like to be able to create an alias ...
A Database was delete
Vito Corleone -
22 Sep 2006 9:45 PM - 3 messages
Bon Journal, Mama Mia! Helppa me. One na of my boysa had da accidently deleted a databasesa fromma MS SQL 2000 Serversa. None of themma hassa comema forwardsa yetta. Are there anywhere in master or mdb or model or other ways that I can write ...
How to update a filed with today
ad -
22 Sep 2006 9:42 PM - 3 messages
I have a talbe, there is a smallDateTime field in it. I want to update this filed with today's date. How can I do? ...
SQL server bottleneck
jhall -
22 Sep 2006 8:11 PM - 4 messages
I have a customer that is operating over a WAN on a T1 line. They are experiencing unsatisfactory performance. (they have tried using ODBC and OLE-DB connection) They gave the application 30% of the bandwidth a put a monitor on it. It never used more than 10% of the available ...
Question about auto update statistics and stored proc recompilation
pshroads -
22 Sep 2006 7:52 PM - 2 messages
I am not clear on the relationship between statistics being updated and stored procedures being recomipled. I beleive that when when auto stats is on then a stored procedure will be recompiled when statistics are updated on a table that the stored procedure accesses. ...
32bit sql on 64bit windows?
Roger -
22 Sep 2006 6:34 PM - 6 messages
We have new servers with 16GB RAM. I want the OS and SQL to use as much of it as possible. I can't put 64bit SQL on the box because the vendor doesn't support that. Can I install 64bit 2003 and 32bit SQL 2000? If so, will SQL be ...
restoring with StopBeforeMark
bajopalabra -
22 Sep 2006 6:23 PM - 3 messages
hi i did : create table pp ( id int ) backup full insert into pp values ( 1 ) backup diff insert into pp values ( 2 ) backup log 1 insert into pp values ( 3 ) backup log 2 ...
Where can I find FoxPro and Visual FoxPro OLE DB data provider
tootsuite -
22 Sep 2006 5:46 PM - 4 messages
Hi, Just trying to find out where I can download the appropriate driver as described in the response below - this particular link (msdn.microsoft.com/vfoxpro/downloads/updates) does not have the download I need - just service packs. THANKS Yes, older format DBFs can be opened with Excel but you will lose the ...
User Defined Aggregate Function For Finding Median
BDB -
22 Sep 2006 4:19 PM - 14 messages
Anybody have any luck with this one? ...
AWE and SQL Cluster
Sean T Shen -
22 Sep 2006 4:19 PM - 10 messages
Hi, I have the following questions regarding AWE on SQL 2000 with Windows 2000 Advanced Server and on a cluster (both nodes have an active SQL Server instance running). The SA has upgraded the memory of both nodes to 8G each. ...
Database Attach Help!!
Paul Glickenhaus -
22 Sep 2006 4:12 PM - 2 messages
Due to space issues we had to detach one of our databases. It stopped working because the drive ran out of space. We have moved the .mdf and the ..ldf to another drive with much more space. When I try to attach I get the ...
Performance and inter-database joins
Tim Greenwood -
22 Sep 2006 4:04 PM - 8 messages
We have ALOT of procs with joins of many tables spanning 2-4 databases at times. Many of these procs are hit HARD during our busiest times. This seems to me that it would be not the best way to do things. I understand ...
Return most recent date
Colin -
22 Sep 2006 3:54 PM - 5 messages
I have multiple rows of results with duplicate information except for one field which is "date". I'd like to return only one "Project_ID" row which means I need to return only the most recent "Stage_Date" field. I've ...
New Install - [WildPacket]
WILDPACKET -
22 Sep 2006 3:49 PM - 2 messages
I am new with SQL 2000. Last night I installed SQL 2000 and attached a database which went well. Whiel doing all this I was logged in as the domain administrator. If I log in as the Administrator adn open the SQL Enterprise Manager I see ...
SQL Server Jobs Refresh
DXC -
22 Sep 2006 3:46 PM - 3 messages
SQL Server 2000. Is there a way to have SQL Server jobs refreshed automatically on a period of time (Like every 30 seconds or every minutes) ? What I am trying to say is that, I can open EM --> Management --> SQL Server ...
DATE CONVERSION
krallabandi -
22 Sep 2006 3:35 PM - 2 messages
How to convert DATE from one format to another. datatype: datetime original format: 2006-09-25 10:48:19.000 I need to convert to 2006-09-25 any TSQL function? I want to do this in a single SQL query. The above ...
SQL Server Desktop
OdieTurbo -
22 Sep 2006 2:53 PM - 2 messages
Hello, I have SQL Server Desktop version 7 running on my laptop. I am using as a data source for Cognos DecisionStream. The issue I am having is that my database has grown quite large. Everytime I try to ...
Strange Error when restoring database
Charles -
22 Sep 2006 2:17 PM - 13 messages
Okay...I'm stumped. I've installed SqlServer 2005 SP1 on my laptop and am trying to restore a customer's database from a SQL Server 2000 full database backup. I've tried through Management Studio GUI and also through a ...
Column type to select data from big tables
MerlinXP -
22 Sep 2006 1:43 PM - 4 messages
Hello, I have a system containing tables with data (number of rows in K or even M). I will be selecting data from these tables using values in one column. Certainly I will make an indeks on this column. I can choose type of this column (int, char) ...
dbcc emptyfile
Nick -
22 Sep 2006 12:57 PM - 10 messages
Hi, (SQL 2K) We used to have a database with 1 100Gb data file I've now created 5 25Gb files and ran the DBCC EmptyFile command to move all the data out of the primary file to the new ones. ...
Cannot shrink database because of StatBlob data on sysindexes
Paul Cahill -
22 Sep 2006 11:10 AM - 7 messages
SQL Server 2000 SP4 Data pages from the image column StatBlob on sysIndexes exist right at the end of my data file. They are stopping me truncating the end of my datafile. I had other tables with text columns. These were moved by either copying the ...
How to rebuild index ?
Peter -
22 Sep 2006 10:32 AM - 4 messages
Hi, We are using SQL Server 2000. A developer asks us to rebuild the index of the database. However, from the BOL, I find that the command DBCC DBREINDEX can be used to rebuild index for a particular table. ...
SQL Server 2000 databases transfrmation
Maikal -
22 Sep 2006 7:59 AM - 3 messages
Hello We have one SQL data base server, on Windows Server 2000 5.00.2195 Serveice Pack 4 Build 2195 and Result of SQL server for select @@version Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 ...
cannot query directory services
Job -
22 Sep 2006 5:40 AM - 2 messages
Dear all, I would like to query informations that are located in the (AD) Active Directory Windows 2003 with my server Windows 2000SP4 and MS SQL 2000 SP4 in the same domain and AD. I create the link server with the following script : ...
Moving to a SAN
Hassan -
22 Sep 2006 5:04 AM - 3 messages
What should one consider when moving SQL Servers to a backened SAN ? ...
Why would the Database Engine Tuning Advisor recommend an non-clustered index if there is already a
plokolp -
22 Sep 2006 4:40 AM - 6 messages
I am trying to tune a SQL Server 2000 database with the Database Engine Tuning Advisor. After analyzing my SQL, it recommended that a non-clustered index be made on a table, however that table already has this field in a ...
restrict enterprise manager to see all the databases
murtix van basten -
22 Sep 2006 4:26 AM - 4 messages
Hi, my question is about security, but I am sure it has something to do with the server configuration. It is about normal users other than SA. In the server, multiple users, and each user has ownership of a ...
SQL Server linked server performance under high-volume scenarios
Joe K. -
22 Sep 2006 3:34 AM - 3 messages
How well does SQL Server 2000/2005 linked server to an Oracle database work with queries that extract high-volumes of data? Is there other alternative ways to extract the data? What are some of the pit falls and problems. ...
Migrate DBs off dying server
Matthew Kitchin (Usenet/Lists) -
22 Sep 2006 3:18 AM - 14 messages
I desperately need some help here. I am the SQL admin by default, but I am by no means an expert. I have a single SQL 2000 SP2 (on Win 2003) server with 26 DBs including the system DBs. They are mostly light use DBs (blackberry, rightfax, antivirus, WSUS, ...
Opportunity to provide feedback on performance improvements in SQL Server...
Umachandar Jayachandran [MS] -
22 Sep 2006 1:03 AM - 5 messages
Please consider giving your feedback or suggestions on the top 5 OLTP and data warehouse performance improvments you would like to see in the next version of SQL Server. Please use the links below to provide your comments. [link] ...
Profiler Question
Buk Usu -
22 Sep 2006 12:52 AM - 5 messages
Hi, on sql server 2000 ... apart from going to the execution plan, is there a way to identify queries that are doing table scans ? thanks ...
SQL Server 2000 - Changing the default paths for data/log files
Conan Kelly -
21 Sep 2006 11:50 PM - 2 messages
Hello all, Is there any way that I can change the default path that SQL Server (Enterprise Manager) uses to create the data & log files in when creating a new DB? The default path is the one SQL Server designated when it was installed (C:\Program Files\SQL Server\MSSQL\Data (or Log)). But we ...
Connection Problem
sara -
21 Sep 2006 11:45 PM - 2 messages
Hi All, I can not connect to sql serve 2005 using SQL Serve Management Studio, I got these error in ERROR.LOG file. Any help is really appreciated. Thanks. 2006-09-21 12:48:21.53 Server Microsoft SQL Server 2005 - ...
SQL 2000 - Convert varchar to datetime or smalldatetime
jdoggz -
21 Sep 2006 10:45 PM - 4 messages
I have a field that contains the following: 091506. That field represents a date. I would like to convert it to datetime in a SQL query. Can anyone tell me how? The field will contain a different ...
SQL Migration from NT 4 to AD win 2k3
feargalo -
21 Sep 2006 10:12 PM - 2 messages
Can anyone direct me to where I can find the steps to follow to move an sql server to a new domain. We are migrating from an NT domain to Active directory win 2003. .. My question is what do we need to consider as regards sql servers when ...
IMPORT DBASE IV (DBF) FILE TO SQL SERVER 2005
tootsuite -
21 Sep 2006 7:18 PM - 10 messages
Hi, I am wondering if anyone knows of a reliable tool for importing Foxpro (dbase) (dbf) files to SQL Server? I have inherted this task from a former employee. I have been using an Access database with an ODBC link to SQL Server for the import task - ...
Logging Autogrow operations in errorlog
Himanshu -
21 Sep 2006 6:51 PM - 3 messages
When database files are set to autogrow, I've noticed that the SQL Server errorlog does not log any information regarding autogrow operations. Is there any way to configure SQL Server to log such operations? Thanks. ...
Amazing scenario
Richard Douglass -
21 Sep 2006 6:02 PM - 2 messages
OK Here it is. The production database was detached so it could be moved. Upon reattachment it decided it was corrupt and refused to allow me to reattach. Another member of the dba team had a physical copy of the MDF and LDF from a ...
set column default value error
Jen -
21 Sep 2006 4:58 PM - 2 messages
Hi, I did an import data from EM by choosing the first option "copy tables and views..". After I copied, the new table doesn't have the primary key, default value anymore. When I tried to set the default value from EM Design Table ...
SQL Server data files modification date doesn't change after resto
Tom -
21 Sep 2006 4:30 PM - 2 messages
Hi, SQL Server datafiles (mdf, ldf) were restored from tapes after the disk replacement (bad blocks' errors were in system log). Now the applications using it (like Ms Project) seem to work properly, however the modification date of those files hasn't changed since the date of the replacement (a week ...
SQL User used for DSN and permissions....
PizzaGood -
21 Sep 2006 3:45 PM - 4 messages
Hi, When I create a SQL user that will be used for a DSN to connect a web app to the SQL Server does the user under Database Access only need PUBLIC or do they need OWNER also? The web app allows users to insert/update/delete records. ...
master database restore
stoney -
21 Sep 2006 3:25 PM - 3 messages
Hi, Have a new sql 2000 server which houses the master db on the F drive. I am trying to restore a master db from a backup from another server but the master db on that server resides on the e drive. ...
Outupt Select directly to a file???
stedyer -
21 Sep 2006 2:48 PM - 3 messages
Is it possible to output a select statement straight out to a file? I have a huge extract to run, which needs to dump various selects out to various text files. at the moment I just run it in SQL Query Analyzer ...
SQL server 2000 transaction log
Tomasz -
21 Sep 2006 2:48 PM - 7 messages
Hi, I've got strange problems with transaction log. My new client has database file 1 GB and transaction log file which is 27 GB! I backed up this file and after that the real data size was 50 MB. But In short time this file was ...
Can I use SQL server 2005 manager to schedule backups?
Sean -
21 Sep 2006 2:47 PM - 3 messages
Can I use SQL server 2005 manager to schedule backups? Any documents for that? Thanks in advance. ...
Fusion Date and Time in a new DataTime field
Carlos A. -
21 Sep 2006 2:09 PM - 4 messages
Hello all I have two fields Date and Time. I've just created a new filed called Date_Time, I need put the old information in the new field. All fields are DateTime type data. Thanks a lot. ...
RESTORE HEADERONLY
SalamElias -
21 Sep 2006 1:58 PM - 5 messages
Hi, can I make a restore headeronly from a share on the network :as follows : RESTORE HEADERONLY FROM DISK = '\\backup1\e$\customer1\Customer.bak'. When I run it on the server itself it works fine, however when I run it from ...
8Gb RAM for SQL Server 2000 on Win 2003
vlad -
21 Sep 2006 1:47 PM - 6 messages
What the setting should be (/3Gb, PAE, AWE) for the best utilization of 8GB RAM for SQL Server 2000 running on Win 2003? Thanks ...
Restoring multiple transaction logs from a single file
niallporter -
21 Sep 2006 1:40 PM - 2 messages
Hi all, I have a home-grown log shipping setup at work which I'm trying to modify. At present if the standby server cannot apply the logs before the live server writes a new set (usually because the db cannot be ...
Help with Recovery
Iyengar.Raghu -
21 Sep 2006 12:56 PM - 6 messages
My W2K Server crashed during a long update operation and now the database is marked Suspect. I have no backup. Is there any way I can revive the database from the .mdf and .ldf files ? Please help. ...
When execute dynamic generated multiple OPENQUERY statements (which linkes to DB2) in SQLServer, I
alingsjtu -
21 Sep 2006 11:58 AM - 6 messages
Hello, every body. When execute dynamic generated multiple OPENQUERY statements (which linkes to DB2) in SQLServer, I always got SQL1040N The maximum number of applications is already connected to the database. SQLSTATE=57030. Background: I created a linked server to DB2 8.1 database which called ...
DB taken offline by getspinlock pre-Sleep() error
David Grant -
21 Sep 2006 10:49 AM - 5 messages
We are using SQL 2000 v8.00.194 on Server 2003 SP1 with 2GB RAM At 00:30 at random day intervals, databases on two different servers are taken offline which causes jobs to be terminated and sessions left open. We ...
Running SSIS pakcage as an agent job using a proxy
Asher F. -
21 Sep 2006 9:58 AM - 6 messages
Hello, I built a simple SSIS package using BIDS. The package does a backup of a DB to a network share. I imported the dtsx file into SQL Server using SQL Server WB (connected to the SSIS server) I created a SQL Agent job to run the SSIS package. ...
How to get the password change date in SQL Server
SMAC -
21 Sep 2006 9:26 AM - 9 messages
I have searched this topic on google first, and I understood that "xdate2 column of sysxlogins" may store this info, but might not exclusively store this info... this value changes as extra permissions is granted. Is there a way to get the password change date? Either within a column of a ...
grat error
vinu thomas -
21 Sep 2006 9:21 AM - 3 messages
Hi, While executing grant alter function to xx gives following error Server: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'function'. Y Thanks BB ...
What's wrong with my SP?
Jason Huang -
21 Sep 2006 9:02 AM - 4 messages
Hi, Here is my SP script: ALTER procedure "TestSPCustomer" @CustTableName nvarchar(20) AS SET ROWCOUNT 10 SELECT CustNo, CustCName FROM @CustTableName ORDER BY CustNo DESC When I run it, it gave me an error saying must declare @CustTableName. ...
.BAK is growing up
Alex -
21 Sep 2006 6:51 AM - 4 messages
Hello ,Folks SQL Server 2000 (sp3) I have posted this question yesterday and still have not got an idea why it is happening. I have a database 11GB and every night I do a full backup (WITH INIT) of ...
What SP is installed on server
moondaddy -
21 Sep 2006 5:10 AM - 4 messages
How do I determin which service pack is installed on sql server? ...
Scope of License, SQL Server 2005 Express
craigkenisston -
21 Sep 2006 5:04 AM - 10 messages
I have designed an application that spread their data over several databases. Actually, it spread its data over several servers, each one with several dozens of databases each. There's just one single server/database that acts as a root directory of where the information ...
Does tempdb use model db as template for creation?
Nikola Milic -
21 Sep 2006 4:50 AM - 2 messages
Hi, Does tempdb use model db as template for creation? I use SS2005, SP1 Thanks in advance Nikola Milic ...
Failed during recovery
Richard Douglass -
21 Sep 2006 3:19 AM - 4 messages
I have been having a lot of trouble trying to reattach a database. The latest issue is that after 9% of recovery I get a primary key violation and it stops. Is there anything I can do to get around this?? ...
Capatibility between 32 bit and 64 bit SQL Server 2000
Ben Mullen -
20 Sep 2006 10:47 PM - 4 messages
Is SQL Server 2000 64-bit edition 100% compatible with SQL Server 2000 32-bit edition? I don't believe there would be any problems with us moving to the 64-bit version, but my supervisor is a bit nervous because a previous ...
Adding NT login using T-SQL
Leon Shargorodsky -
20 Sep 2006 9:36 PM - 2 messages
Is it possible to create new login (NT or Windows) using T-SQL? sp_addlogin doesn't seem to have this capability. Thank you in advance for your help! ...
script to enable auto-create stats on all databases
Hassan -
20 Sep 2006 9:30 PM - 2 messages
Can i have a script that will enable the auto-create stats on every database in one click if not already done so ? Thanks ...
detached db cant recover
Richard Douglass -
20 Sep 2006 9:22 PM - 6 messages
A genius here at work decided to detach a database because the disk the log file was on was full. He copied the log to a different drive and now we cant reattach the db. The db is 260 gig, the log us 70 gig. SQL Server ...
How can I totally remove a connection in a DTS
Gus -
20 Sep 2006 8:55 PM - 3 messages
Hi, when I remove a connection by clicking rigth button delete, this is removed in the graphic enviroment, but the connection is still in the DTS when I select the option Disconnected Edit and expand the connection node. Could somebody give me a tip to solve this, because is not good to see ...
Tough Transaction Problem with Stored Procs and ADO.
LineVoltageHalogen -
20 Sep 2006 8:43 PM - 4 messages
Greetings All, I was hoping that someone might be able to shed some light on a problem I am having. In short I have an application written in C# calling a stored proc. Without going into the reasons why (it is ...
need SQL Query Help
mli -
20 Sep 2006 7:24 PM - 2 messages
I need help with a query, i have two tables, name Qty orderID Store Paper 1000 101 New York ...
sql server logs full
dmalhotr2001 -
20 Sep 2006 7:01 PM - 4 messages
Hi, I'm running a giant update on a sql server. The drive has about 4 gigs for space free. The log is about 1 mb. When I run the update query (17 simulataneous updates to different tables without a transaction), ...
restore help
stoney -
20 Sep 2006 6:14 PM - 5 messages
Hi, I am able to restore the master db from a backup from server a to server B without anyproblems. I detach model without a problem. but when I go to restore I get tempdb is skipped, you cannot run a query that requires tempdb. ...
Re: SQLIO tool : Wheres the test file ?
JPC -
20 Sep 2006 5:52 PM - 2 messages
Can anyone tell me how to create the .DAT test data file for the SQLIO utility ? ...
converting some t-sql queries to work with MS ACCESS
ashley.sql -
20 Sep 2006 5:49 PM - 2 messages
how do i convert this statement to work in MS ACCESS. These are some statements I use in SQL server now they are required for a database in access. They do not work. Anyone knows if it is possible to write them ...
Reporting services
vishnu.nallamothu -
20 Sep 2006 5:44 PM - 2 messages
Hi I would like to know how to create a file programatically(VB) in the reporting services folder, so that it can be accessed from the report manager. ...
Strip out Alpha Character
angela.y.austin@gmail.com -
20 Sep 2006 5:33 PM - 2 messages
I'm importing a 10 character zipcode field with a "-". I'd like a command that only imports only numberic characters. Can anyone help? I'm currently using LEFT(ZipCode, 5) + RIGHT(ZipCode, 4), but would prefer to use something more efficient. Thanks for your help! ...
Strip out Alpha Character
angela.y.austin@gmail.com -
20 Sep 2006 5:33 PM - 4 messages
I'm importing a 10 character zipcode field with a "-". I'd like a command that only imports only numberic characters. Can anyone help? I'm currently using LEFT(ZipCode, 5) + RIGHT(ZipCode, 4), but would prefer to use something more efficient. Thanks for your help! ...
Shrink data file issue
Alex Cheng -
20 Sep 2006 5:02 PM - 3 messages
Hi there, For some reason, when I tried to shrink the datafile it can never finish and it cost all the query to timeout. The way that I solved the problem is to restart the SQL Server engine. Does anyone know what happen? ...
Growing Log File
Emma -
20 Sep 2006 4:56 PM - 5 messages
A third party application we are using uses MS SQL 2000 as its database. Unfortunately, the log file for the associated database grows from about 500MB to over 40GB in one day and we keep shrinking/truncating the log file ...
SQL structure - what if???
WANNABE -
20 Sep 2006 4:47 PM - 3 messages
HI, I walked into a situation where SQL runs and seems to work ok, but the more I look at things and how they are not as they should be (DEEP BREATH) well I don't like it, but I ask myself should I try to fix what seems to ...
Install SP1 on SqlExpress RTM
Martin Robins -
20 Sep 2006 3:41 PM - 2 messages
I currently have SqlExpress RTM (build 1399) installed and wish to upgrade it to SP1. I can only find installers for (a) SqlExpress including SP1 or (b) SP1 for all of the other editions. I do not want to have to de-install and re-install SqlExpress in order to ...
user need to execute scripts - what rights show i give ?
Scott -
20 Sep 2006 3:23 PM - 2 messages
i have users connecting to SQL server 2005. how do i set them up to allow give them the ability to execute scripts that create tables, data, SPs ? im using Windows Authetication and all Domain users have been added but with ...
check access to DB based on a systable??
Kenny -
20 Sep 2006 1:56 PM - 3 messages
I have this query to search whether a stored procedure uses a certain text string (or whether a table is named like this text string). I use a cursor to "scan" all the databases. It works fine except for the ...
moving SQL Server from one domain to another domain
Cary Shultz -
20 Sep 2006 12:28 PM - 4 messages
Good morning! I am not a SQL person so this might be a bit of a silly question. Anyway, here goes: Is there a problem moving a SQL Server from DomainA to DomainB? Here is the situation. Client has one subnet (10.10.x.x) but two Domains (one WIN2000 AD and one ...
Indetifying views in profiler
Buk Usu -
20 Sep 2006 11:31 AM - 4 messages
Does anyone know of a way to identify views from profiler ? I have poorly performing views on a large system and no direct way to point back to one particular one Thanks ...
audit database user creation
vinu thomas -
20 Sep 2006 10:53 AM - 6 messages
Hi, Is it possible to find out ‘Who’ created a specific database user in database? Thanks bb ...
Help with Bkup jobs
Ana_T -
20 Sep 2006 10:27 AM - 5 messages
Hi, I have a daily job programmed to backup two sets of dbs with their respective BAK and TRN extensions. Job 1 is executing normally creating the backup files BAK and TRN but job 2 is only creating the BAK file and not the TRN. ...
disable all SA accounts remotly - access only for low user ?
Scott -
20 Sep 2006 10:16 AM - 2 messages
Hi, I need to access my web based SQL 2005 express edition database on 1433 using a user with minimal privileges that can only run a stored procedure. I do this by connecting to IP / port. Is there anyway I can disable SA using this same method but still allow SA ...
Move 2005 cluster to new hw
Ole Thomsen -
20 Sep 2006 9:18 AM - 3 messages
I will have to move a 2-node SQL2005 MSCS cluster to new servers. Wonder if I could just - remove node1 from cluster - add node3 to cluster - remove node2 from cluster - add node4 to cluster Is this a valid plan? ...
Schedule for the sqlagent from the command line
Erik -
20 Sep 2006 9:06 AM - 2 messages
hi How do I set-up a schedule for the sqlagent from the command line /Erik ...
Help with ALTER COLUMN needed
Thomas Due -
20 Sep 2006 7:34 AM - 6 messages
Hi, I have a database, in which I have made a mistake regarding the datatype of several columns. So I found out that I could use ALTER TABLE dbo.Plant ALTER COLUMN coreweight numeric(12,2) CoreWeight is originally defined as an INT. ...
Transfer Microsoft Access Data to SQL Server
winwin via SQLMonster.com -
20 Sep 2006 4:25 AM - 3 messages
Hi, I'm new to SQL server, and I would like to achieve below tasks. Kindly provide brief guildline on how to achieve these: 1.) I have managed to schedule job in SQL server to download the access database from remote server ...
Like % % help in stored procedure
Bonzol -
20 Sep 2006 3:41 AM - 3 messages
Hey there, I've been using the like function PREFECTLY for about a year now in classes ect. But now i'm trying to do it in a stored procedure and it wont work ,it's driving me crazy I've tried many differnt examples,, ...
displaying remaining records
jscarrozzo -
20 Sep 2006 2:34 AM - 3 messages
Hello all. Quick rundown of what I need to do. I am pulling cartons(or we can call them fruits) to make pallets of 25 cartons. Lets say there is 27 apples in inventory, and i need to make a pallet of apples which ...
Keep only X # of backups when appending to BU file
Dan -
20 Sep 2006 1:34 AM - 3 messages
Using SQL Server 2005 STD, is there a way to create a maintance plan to backup the database, appending to a file, but only keeping the last X number of backups? I would like to keep 4 full backups at a time. When the 5th backup occurs, I ...
Two-Way Replication/Mirroring
VictorGarret -
19 Sep 2006 11:02 PM - 2 messages
Problem Currently: Web Servers and Internal Users point to the same database. Web site needs to run as fast as humanly possible, read/write access to the database. Internal users import data and read data that will need to make its way ...
SQL 2000 Backup (Native)
tractng -
19 Sep 2006 10:47 PM - 5 messages
Guys, I have a database (.mdf) the size of 4.2 gb. The previous admin had use the native backup from MS that comes with sql 2000 and it backups on daily. Under management --> jobs BACKUP DATABASE [tkcsdb] TO DISK = N'C:\Program Files\Microsoft SQL ...
|
|||||||||||||||||||||||