Home All Groups Group Topic Archive Search About

Microsoft SQL Server Administration

microsoft.public.sqlserver.server
Score Is it really nessesary
caspervt - 24 Feb 2007 3:09 PM - 3 messages
I installed the small business server 2003 and are conserned with memory use of sql server. What is the sql server used for. Can I just uninstall it or is it required by the operating system itself? ...
Score Memo Data Type
doodle - 24 Feb 2007 2:03 PM - 7 messages
I am transferring my access backend to sql 2005. access has a memo data type. I tried using NVarChar(MAX), it will let me enter 254 characters. Then it gives me an error that the field is too small - it ...
Score Memo Data Type
doodle - 24 Feb 2007 2:03 PM - 2 messages
I am transferring my access backend to sql 2005. access has a memo data type. I tried using NVarChar(MAX), it will let me enter 254 characters. Then it gives me an error that the field is too small - it ...
Score Maintenance Plan Changes in SQL Server 2005 SP2
Ed Lehman [MSFT] - 24 Feb 2007 8:47 AM - 3 messages
Users of SQL Server 2005 maintenance plans should be aware of a change in SP2 that affects existing cleanup tasks until updated using SQL Server SP2 tools. Who is affected? You are affected if you use SQL Server 2005 maintenance plans, those plans ...
Score Advanced Transact_SQL
elisacarli - 24 Feb 2007 5:40 AM - 3 messages
Hi everyone I've a problem. I must convert a query dinamically composed in an ASP script, in a stored procedure The Visual Basic code is below. Could you help me anyway? SELECT ID,titolo,sottotitolo,data,file FROM tbl_promozioni WHERE ...
Score Concatenating a fully qualified name
morphius - 24 Feb 2007 4:41 AM - 2 messages
In the code below, the DatabaseName and table_id are variables. The table_id is OK with the @table_id. But, how do I make DatabaseName equal to @db so that I can pass it to the parameter @database. In other words, how do I ...
Score question about DMV index_usage_stats
Adam Clark - 23 Feb 2007 9:01 PM - 2 messages
I am still a bit new to DMV's and DMF's. How do I figure out what index_id is referring to? Like I want to know the actual name of that index. For instance, I can use the function database_name() to determine the actual ...
Score DELETE not deleting all records..mystery.
donsql22222 - 23 Feb 2007 8:33 PM - 2 messages
I've got a job that has 3 lines and it reports success after it runs. DELETE FROM TABLE1 WHERE DATE >= '20070115' DELETE FROM TABLE2 WHERE DATE >= '20070115' DELETE FROM TABLE3 WHERE DATE >= '20070115' I then have a separate job for each line below which imports from another ...
Score What does MS recommend
thejamie - 23 Feb 2007 8:06 PM - 4 messages
Deploying our most intensive object - activity billing - and trying to determine whether to crunch on an 8 GIG 2003 Windows 64 bit server running Std SQL Server 2005, or to run same using a VS 2005 studio application, or to ...
Score Creating a variable to hold a table/view name
Conan Kelly - 23 Feb 2007 8:02 PM - 2 messages
Hello all, Is it possible to create a variable in a SQL script to hold a table/view name? Alot of my scripts are union queries where each part refers to the same table/view, and sometimes those sources need to be changed.  It would be ...
Score deleting an instance of SQL Server
Rich - 23 Feb 2007 8:01 PM - 2 messages
We have a server with with four instances of SQL Server 2000 running on a server with Win2003.  On of the instances (not the default) was a Biztalk development server.  Well, I want to delete that old SQL Server instance and ...
Score SQL 2005: Extremely long running "Crosstab" script when based on a view vs. a temp table of the view
Conan Kelly - 23 Feb 2007 7:51 PM - 3 messages
Hello all, We have a "Pivot Table"/"Crosstab" script that I tried running on a view. It was taking for ever.  I let it run through an hour lunch and it still hadn't finished. I decided to try a SELECT * FROM the view that it was trying to use.  That ...
Score The partner transaction manager has disabled its support for remote/network transactions.
timothy.alvis - 23 Feb 2007 7:42 PM - 5 messages
I receive this error when running a remote stored procedure through a local stored procedure. As in: EXEC [REMOTE-SERVER].[DB].dbo.[StoredProc] No error in a query window, but when inside a stored procedure I receive the error above. The full error message is: ...
Score MSDB database restore
Paul Oren - 23 Feb 2007 6:19 PM - 5 messages
I am trying to restore the msdb to another server. When I do, I get the following message: V-79-57344-33938 - An error occurred on a query to database msdb. V-79-57344-33938 - The backup of the system database on device ...
Score SQL Server
S - 23 Feb 2007 2:55 PM - 4 messages
Hi I have sql server with 10 GB mdf file, and 10GB ldf file. Should the ldf file be 10GB or I can something to make it small? Than'x Shay ...
Score Enable Common Criteria Compliance
Al - 23 Feb 2007 2:47 PM - 3 messages
SQL 2005, SP2 In the Security section of the Server Properties dialog in SSMS, there is a check option for "Enable Common Criteria Compliance". In the online help, this position is listed as the "Allow Direct Updates to System Tables" ...
Score Error in Sql Server 2000 sp4
Luis - 23 Feb 2007 2:26 PM - 2 messages
I´ve got a problem with SQL server. The server stops responding and gives me out an error below. Anyone can help me. When it runs this select in the database the server keeps with 80% 100% processor up and stops responding all client requests. ...
Score Connecting JSP app to Win SQL using windows auth.
Harperator - 23 Feb 2007 12:48 PM - 2 messages
Hi- I wrote an app years ago using jsp, and life has been good, it just hummed along quietly passing the password and username in the connection string ex: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:old_way","user_name","pass_word"); ...
Score Hw to get Schema file through DTS
Dutt - 23 Feb 2007 6:41 AM - 2 messages
Hi, Cud anybody tell me how to get schema as a DTS file? Its urgent. Thanks, Dutt. ...
Score Yet another mirroring question
Hassan - 23 Feb 2007 4:28 AM - 2 messages
In the mode where there is a principal, mirror and witness, what happens when the mirror goes down ? Is the pricipal still up and running and servicing requests or is it basically offline since it cannot commit its changes to the mirror ? ...
Score Transaction Log Backups too big
fnadal via SQLMonster.com - 23 Feb 2007 3:15 AM - 7 messages
I'm pretty stumped on this one. Here's the background. Production server, logs backed up every half hour, sql server enterprise edition, full recovery model, SP3. The server is replicating to another server. The backup log files are averaging 500 megs to 2 gigs each half hour. Our ...
Score Find Records with duplicate values in 1 row keyed to 2 other rows
Joe S. - 23 Feb 2007 12:19 AM - 2 messages
My table looks like this: rowid, tenantid, chargecode, date, amount, ............. I need to get all rows that have multiple entries on the same date(mm/yyyy)  for a given combination of tenantID and chargecode. for example: 1   tenant1   5       1/1999   $500 ...
Score Backup/Restore databse - "physical_backup_device_name"
xtonysun - 22 Feb 2007 9:51 PM - 3 messages
Hi, I ran into a command today like RESTORE DATABASE  testdb FROM DISK = N'E:\MsSQLServer\Backup\MyDb.bak' WITH FILE = 7..... Does anyone know what the letter "N", right before the physical_backup_device_name  'E:\MsSQLServer\Backup\MyDb.bak', is ...
Score sql 2000 liscencin mode
Elbryyan - 22 Feb 2007 9:48 PM - 2 messages
Is there an easy way to tell which type of liscensing mode you are using, ie per CPU or per device cal? ...
Score What is SYSREMOTE_FOREIGN_KEYS ? a table or a stored ?
fischermx - 22 Feb 2007 9:39 PM - 2 messages
It looks like a table. When I script it, it creates a table statement. And it is in the system tables folder. But it behaves like a stored procedure ... if you try to "open" it with SQL Analyzer it expects parameters ! ...
Score SQL 2k4 SP2 x64 failure on security - domain trusts ??
Steve M - 22 Feb 2007 9:15 PM - 3 messages
Hi - I just tried to install SQL2k5 SP2 (x64 edition) on an x64 machine, as a user that a member of the admin group on the machine, and got some errors. It was a plain vanilla SP2 install on a plain vanilla default instance. All the ...
Score OT: Google Groups dropping messages?
Tracy McKibben - 22 Feb 2007 8:28 PM - 2 messages
Anybody else here using Google Groups to read/post?  Have you noticed that you miss new messages?  I've seen numerous responses in the last two days where the original message was missing from the message list.  Just curious if it's affecting everybody, or just me... ...
Score Data Partitioning (SQL Server 2005)
Leila - 22 Feb 2007 7:59 PM - 2 messages
Hi, Assuming that I have partitioned my Orders table based on OrderDate column on 4 disks (each quarter on separate disk), do I need 4 processors for real parallelism? I mean if a query needs the orders of 3 quarters, will 3 disks prepare the ...
Score Looking for SQL Recruiting agency
Chris - 22 Feb 2007 7:27 PM - 2 messages
I'm sure many of you MVP's are independents, but we are looking for a single SQL Server specialist for a large project and were looking for a respectable agency for finding VERY high level candidates. New system will be multi-million transactions per day. [Clustered VLDB]. ...
Score Check Constraint UDF: Update vs. Insert
rich - 22 Feb 2007 6:46 PM - 9 messages
I am using a check constraint on one of my tables. It appears to me that the constraint processes an insert AFTER the row is inserted on an insert, but BEFORE the data is updated on an update. here's my ...
Score Creating a Date - or Time - Only Column in SQL Server
GeorgeAtkins - 22 Feb 2007 6:28 PM - 3 messages
I understand that in SQL Svr 2000, all date/time fields store both the date and the time. Is there a way through a constraint or trigger to force a table to store only the date portion or time portion of the entry? For example, a ...
Score Search for text in a procedure
thejamie - 22 Feb 2007 6:01 PM - 2 messages
Trying to pull up the text from all the procedures, insert it into a string variable and search it for a given string... not having success: Declare @procname varchar(200),@sql3 nvarchar(4000) declare  Prox cursor for select name from sysobjects where xtype='P' order by name ...
Score Is it possible to restore/recover an old view after it's been chan
Chesster - 22 Feb 2007 4:08 PM - 3 messages
Subject is the question. Thanks for any help. ...
Score Primary file group full
danielp - 22 Feb 2007 3:21 PM - 2 messages
I have inherited a SQL server 2000 DB where the system and user tables are separated into different mdf files (on separate drives).  The primary file group is the system data.  I have a query that is returning data from a remote DB table which is not in the local DB ...
Score How to save SQL 2005 solution?
nomad - 22 Feb 2007 3:18 PM - 3 messages
Hi, I have a solution within SQL 2005, which contains scripts of all stored procs and views so that they are in source control.  My question is, how can I save this so that every time I open up SQL 2005 ...
Score Parameterized queries taking more time
Chakravarthy - 22 Feb 2007 3:14 PM - 3 messages
Do parameterized queries take up more CPU resources than if the where clause values were hard coded ? Thanks. ...
Score SQL Server 2005 Auto-Partitioning
jatin.grover - 22 Feb 2007 2:59 PM - 6 messages
Hi: I know SQL Server 2005 is a shared-nothing DBMS, but what if I have one instance of SQL Server 2005 connected to a multi-spindle storage solution, like Dell MD-1000, which has 10 physical hard drives. If I ...
Score "Filling in the gaps" with a single-line query
Velislav - 22 Feb 2007 2:48 PM - 3 messages
Hi, I've got the following scenario: Files are being stored in a database, with a number of name-value pairs associated with each file. This happens by storing the files in one table (File), the list of property names in another table ...
Score Database diagram
ciupaz - 22 Feb 2007 2:34 PM - 2 messages
Hi all, is it possible (with SS2005) to create a database diagram with the arrows near the tables' fields that have a relation? With my SQL Server 2005 database diagram, the arrows are placed casually, not near the fields that are related with other tables. ...
Score OSQL using login in a different domain
DML - 22 Feb 2007 2:21 PM - 3 messages
I have a server that is on one domain and I need to log into another domain.  I can do it using a standard sql login, but I'd like to do it using a domain login in that other domain. ...
Score How to define the column size in the query
superbaby - 22 Feb 2007 2:06 PM - 3 messages
I use SQL Server 2000 Enterprise manager to exporting some data out from database to a text file. I specified in DTS, about the look of text file. but my output is like this: 0000500628;J;7200;J;Scania Beers B.V.                  ;Smaragdweg ...
Score SQL Server 2000 SP4
usenet - 22 Feb 2007 12:56 PM - 6 messages
I've installed SQL Server 2000 SP4 successfully on most of our instances.  However, on a few of the instances the @@VERSION still shows as RTM.  There were no errors reported during the installation. What is the best way to diagnose/resolve this problem? ...
Score err: The BackupDirectory registry key is not configured correctly. while Restore?
mtczx232 - 22 Feb 2007 9:25 AM - 2 messages
I try to restore DB from SQL2000 DBK file, the SQL Management Studio create this script: RESTORE DATABASE [xxx] FROM  DISK = N'P:\xxx_db_200702150015.DBK' WITH  FILE = 1,  MOVE N'xxx_dat' TO N'H:\xxx.mdf',  MOVE N'xxx_log' TO ...
Score Why Invalid Connection?
Q. John Chen - 22 Feb 2007 6:01 AM - 7 messages
I am replacing a Shared SQL server database (2000) with SQL 05 Express. I setup the database on the same Windows 2003 server as the web server. I also have WinForm app on the same machine. Both web app and winApp are written in .NET1.1 and didn't bother to upgrade for ...
Score Restore full DB backup and transaction log backup which backed-up at the same time
wodoy.peter - 22 Feb 2007 5:51 AM - 11 messages
Consider the following scenario: - Full backup was scheduled to run daily at 12am - Transaction log was scheduled to run every 30 minutes since 12am Question: Since the transaction log is scheduled to run every 30 minutes, the 48th transaction log backup will be performed at 12am midnight, which ...
Score Data missing after transaction committed
Ryan - 22 Feb 2007 2:45 AM - 2 messages
We have discovered a very strange anomaly in one of our databases yesterday. The database is being run on SQL 2000, and has been running problem free for about 5 years, until an isolated event yesterday. In simple terms, a transaction that has been committed is "missing" from the ...
Score SQL 2005 SP2 version number
circulent - 22 Feb 2007 2:34 AM - 3 messages
Can someone please confirm if v9.0.2047 is SP2? Thanks ...
Score odbc to progress db
Andy - 22 Feb 2007 12:38 AM - 4 messages
I have users that thru and ODBC connection to my Sql2000 db attach tables and query different information. Now they need to read data from a Progress database on Unix to pull some values from a table. I have the ODBC driver ...
Score What ports does Sql Server use?
David Thielen - 22 Feb 2007 12:16 AM - 5 messages
Hi; We have to open a hole in our firewall (just allowing from 1 outside IP address) for a .NET app on that outside server to access Sql Server 2000 via ADO.NET. What ports do I need to open? ...
Score SQL Server 2005 Fatal error
datageek - 21 Feb 2007 11:48 PM - 2 messages
We are not aware of any changes to our SQL Server 2005.  It gave out the below error when we try to connect to Object Explorerer yesterday.  SQL Server is always using 25% CPU time. There is another instance running on the same machine and it works ...
Score Schedule export from sql database to access
Ricky - 21 Feb 2007 11:46 PM - 2 messages
Hi Can someone explain/help how can I create a schedule at SQL Server 2000 that exports at X time of the day a SQL database into a access database without exporting the views that the SQL database has. Thanks ...
Score Change column from datetime to int
Ron Hinds - 21 Feb 2007 11:38 PM - 2 messages
I want to change a column from datetime to int. I'm using this T-SQL: ALTER TABLE WebPages ALTER COLUMN EndDate int; I get this result: Server: Msg 260, Level 16, State 1, Line 1 Disallowed implicit conversion from data type datetime to data type int, ...
Score Enabling Replication Question
dfrazell - 21 Feb 2007 11:31 PM - 4 messages
Can I enable replication from a different server that has Enterprise Manager install than the one that hosts the SQL database without any problems or side effects? I cannot enable replication from my server (Server A) hosting SQL Server because the registration name is (local) instead of the server ...
Score SQL Server 2005 Edition feature comparison
Steve B. - 21 Feb 2007 9:36 PM - 3 messages
A few weeks ago, I found an on-line tabular comparison of the features in the different editions of SQL Server 2005. I neglected to bookmark the site, and now I cannot find it again. Can anyone point me to it? Many thanks... ...
Score Trying to add single quotes to a string variable
dan.forest - 21 Feb 2007 8:57 PM - 4 messages
I have a text field that contains a comma-delimited list of IDs. I want to build that information into a single-quote list, the type you pass to the IN() function. However I can't seem to figure out how to ...
Score Concatenating string variables doesn't appear to work properly
dan.forest - 21 Feb 2007 7:42 PM - 5 messages
When executing the following statements: declare @x char(10), @y char(10) set @x = 'abc' set @y = @x + 'def' select @x select @y the results are: abc abc I expect @y should be equal to 'abcdef'. If I change the var types to ...
Score Recommendations for SQL Server 2005 books
Kumar VK Moorthy - 21 Feb 2007 7:35 PM - 3 messages
Hi, I am new to Sql Server 2005. We are currenly migrating from Informix/AIX. Any recommendations for a Comprehensive book on Sql Server 2005. Focus on administration with coverage on development will be wonderful. Thanks. Kumar. ...
Score How to Document my Database?
Leila - 21 Feb 2007 7:14 PM - 4 messages
Hi, I want to document a huge database, but I don't know where to start, what to document. Are there any samples or tools for this job? What should be documented? Thanks in advance, Leila ...
Score Missing Log - Suspect Datanbase - HELP!
Richard Douglass - 21 Feb 2007 6:13 PM - 3 messages
A customer called me and said they ran the disk out of space, rebooted the machine and the activity log is complaining about the database log being already in use, and being out of disk.  The database is in suspect mode, and ...
Score assign variable to an XML query's result
bbla32 - 21 Feb 2007 6:08 PM - 2 messages
Can I set output of an XML query to a variable (SQL Server 2000)? The following query does not parse: DECLARE @Xml NTEXT SET @Xml = (SELECT D.* FROM WSDMS..Documents D WHERE D.ID = @DocumentID FOR XML AUTO) ...
Score Restore DB Failed
jeff - 21 Feb 2007 5:28 PM - 7 messages
SQL server 2005 Try to restore database, Can not restore it because Do not have exclusive access. Have .DLL constantly connect to the database. How could I restore database without stop SQL service Thanks in advance Jeff ...
Score Calling a stored procedure multiple times
BillGatesFan - 21 Feb 2007 5:00 PM - 3 messages
This is probably an easy question but when I call a stored procedure from my website multiple times sometimes it return data and sometimes it does not. The stored procedure just contains a select statement in it. Could it be that I'm locking the table and it cannot access it? I ...
Score How to Restore a Database - SQL Server 2000
Socrates - 21 Feb 2007 4:43 PM - 10 messages
HELP!!! I mistakenly dropped a production table while migrating some views using DTS. I didn't uncheck the "Include all Dependent Objects" option and the view I was updating was dependent on this table. This is an append table with approximately 10 months of history. Is there a way I can restore the ...
Score re-try on replication
tolcis - 21 Feb 2007 4:15 PM - 3 messages
Hi! How to change the number of re-trys in transactional replication before it times out?  Currently (by default) it is set to 10.  I would like to increase it to 30 or 40. Please advise. thank you, ...
Score Replication and Reports
tolcis - 21 Feb 2007 4:13 PM - 3 messages
Hi! I have transactional replication setup to a remote server.  My application is pointing to that server for reporting function. Everytime I ran a report it locks the replication and replication times out.  In my reports I specified No Lock (not sure if this did ...
Score join many MDF into one
Steffen Meier - 21 Feb 2007 3:41 PM - 8 messages
Hi, I have a MSDE2000 installation. There I have 120  MDF files \ databases with alltogether 10GB. All databases have an identical structure (same tables etc.) Is there a way to join all databases into one big database? I would then attach this big database to an SQL2000 Server and run some ...
Score SQLWB.exe Application Error
Davey Nauth - 21 Feb 2007 3:33 PM - 2 messages
I tried to open SQL Server Management Studio and it gives an error message "The application failed to initialize property (0x00000135). Click on OK to terminate the application" And even I tried to open SQL Server Configuration Manager and it gives an ...
Score Change to behavior in SQL 2005 SP2?
Michael D'Angelo - 21 Feb 2007 3:20 PM - 10 messages
I just applied SQL 2005 SP2 to our SQL 2005 server.  We have a maintenance plan that does a transaction log backup on all databases every hour.  Prior to SP2 (running build 2153), the maintenance plan would silently skip ...
Score Round Time To Nearest 15 Miniutes
Izzy - 21 Feb 2007 3:15 PM - 5 messages
I wrote a function to round time to the nearest 15 miniute interval. This functions works fine, I'm just wondering if anyone has a more efficient\better method of doing this. CREATE FUNCTION RoundToNearest15 (     @Date    SMALLDATETIME ...
Score NT Authority\System Account Issue
myrights99 - 21 Feb 2007 2:44 PM - 2 messages
I came across the issue where NT Authority\System Account is been removed from SQL Server 2000 (Security) & i have to add this back. SQL Server Services is running under SYSTEM ACCOUNT. Any help how to add back NT Authority\System Account will be appreciated & thanking in ...
Score Schemas vs. Users
ciupaz - 21 Feb 2007 2:28 PM - 5 messages
Hi all, just a few question about schemas and users. Is it a good practice to use schemas to put objects in it? (tables, sprocs, ecc.) Is it possible to change the default schema of the current user? Is it possible to create a table with a different schema of the ...
Score Error 1053. The service did not respond to the start or control request in a timely fashion
wn123456@gmail.com - 21 Feb 2007 2:21 PM - 4 messages
I have a setup with SQL 2005 installed on x64 win2003. After i register a 32 bit NT service, it fails to start. Always get error "Error 1053. The service did not respond to the start or control request in a timely fashion" ...
Score Help with SQL 2005 solutions
nomad - 21 Feb 2007 1:48 PM - 9 messages
Hi, I want to be able to use source control from within SQL 2005.  I know how to add a new solution with a project attached.  And I know how to add existing .sql scripts to it.  My quesiton is, how can I split them ...
Score Authentication Error with HTTP EndPoints
jahu - 21 Feb 2007 11:46 AM - 3 messages
Hello! I'm unable to use a webservice exposed on a Sql Server 2005 by using the MSSOAP.SoapClient in Excel 2003 with VBA. The aim I'm focuced on, is to write a function for a Excel Sheet wich resolves some ...
Score Copying/migrating SQL 7 Databases over to SQL 2005
nade - 21 Feb 2007 10:36 AM - 2 messages
Hi, I've been trying to work out how to copy 2 small databases from an old SQL7 server to a new 2005 server. I'll admit straight away that i'm totally new to the world of SQL, so i'm stuggling a little. ...
Score Need some help about DTS
superbaby - 21 Feb 2007 9:02 AM - 2 messages
I have create a DTS package, This job is fist connect to database, and then excute a SQL query, then use the VB ActiveX to create a procedure to store the sql result to a text file. I ran the package there is no ...
Score Why Backup the Master ?
Double_B - 21 Feb 2007 5:57 AM - 3 messages
Hi We have a SQL Server 2000 Server. Currently there is only 1 user DB on that server with 10 logins .. I have an excel sheet that contains the loginname & passwords of the 10 users. I was wondering why is the MASTER DB important ....Lets say if my ...
Score Problem in Creating Trigger Sql Server 2000
Rahul - 21 Feb 2007 5:18 AM - 5 messages
Friends,   I have problem to creating a trigger.   In a trigger, i have check, if both inserted and deleted table has row, then Check containt in both tables are same or not like this   Select Count(*) from inserted i , deleted d where i.cola = d.cola ...
Score Sproc compiles every time it runs
Hassan - 21 Feb 2007 4:35 AM - 5 messages
Everytime I run a sproc in SQL 2000, my compilations/sec increase in perfmon but recompilations/sec remain at zero. What I want to know is what causes the sproc to compile every time it runs ? I followed the link in brief ...
Score shrinkDB
msnews.microsoft.com - 20 Feb 2007 11:40 PM - 3 messages
I have database A the Transaction log is filling up the Drive, I backed up the Transaction log and wanted to shrink the log file to get back the Space. I am not able to get back the drive space  however the log is shrunk. help ...
Score want dumb help: syntax for extracting an ID substr from my field
kenfine - 20 Feb 2007 10:18 PM - 2 messages
I'm hoping someone can offer the "gimme" on this one rather than sending me to the docs (where questions like this probablybelong...) I'm storing URLs in a SQL server varchar field: [link] ...
Score make UDF invisible in SQL2k
mecn - 20 Feb 2007 9:51 PM - 3 messages
Hello, anyone knows how to make a UDF invisible... Thanks, ...
Score Date query
Shan - 20 Feb 2007 9:24 PM - 3 messages
I have a query which finds records that are >=  todays date.  The user has requested that I should display the records a year back from todays date in addition to >= todays date.  I'm using the following "where" clause. ...
Score Error message code 8621 : The query processor ran out of stack space during query optimization
François - 20 Feb 2007 9:05 PM - 6 messages
Hi, I'm facing problem with sql request with SQL Server 2005. I have a 3-tier architecture. I'm using a web application running under Tomcat and storing data in SQL Server. The Web application uses ro connect to SQL Server the JTDS JDBC drivers. ...
Score Cascade Delete Error on FK
Ryan - 20 Feb 2007 7:42 PM - 4 messages
I'm getting the following error when I try to set the Delete action for a relationship to Cascade.  What I have is 4 tables.  The base table, a child1 table, a child2 table, and a child1_mm_child2 table.  For each Base object ...
Score SQL Server 2005 exclusive audit events
Kumar - 20 Feb 2007 7:28 PM - 2 messages
Hi All, I am trying to find out  all audit events exclusive to sql server 2005 . (i.e Audit events that are not present in sqlserver 2000  but in sqlserver2005) In sql server2005 books online, they gave all events. ...
Score Max records in SQL table
Fred Wouters - 20 Feb 2007 4:12 PM - 6 messages
Hi, Can someone please tell me what the max record count in a table in SQL Server 2005? I ask this because I have a process which generates 7.000.000 records of data in 1 day. Thanx in advance, ...
Score Is SQL2k Reporting Services same as SQL2005 Reporting Services?
Phillip Vong - 20 Feb 2007 3:36 PM - 2 messages
I just want to make sure.  Can the reporting services for 2k do everything 2005 can do? Thanks! ...
Score deleting multiple databases on 2000
stoney - 20 Feb 2007 2:07 PM - 4 messages
Hi, I need to delete approx 50 db on the same server.  Instead of deleting one at a time, is there a better way?  Is there a script that someone can suggest many thx ...
Score Database restore fixes problem - why?
Jeff - 20 Feb 2007 1:54 PM - 10 messages
We are using a SQL Server 7.0 database for a financial software package that we use.  Every year we run into problems with the software package not working properly on a certain function.  The solution to fixing the problem ...
Score multiple SIDS sql2005
Mark Broadbent - 20 Feb 2007 12:06 PM - 2 messages
Hi all, I was a bit surprised upon performing a sp_who2 to find several groups of spids (see screen shot). Could this be explained because asynchronous queries might be being used (I am not aware that they are) or is this something specific to the .net provider. ...
Score MSSQLSERVER Error 17052
Eggbert - 20 Feb 2007 9:59 AM - 12 messages
Event Type:    Error Event Source:    MSSQLSERVER Event Category:    (2) Event ID:    17052 Date:        2/20/2007 Time:        4:38:39 AM ...
Score SQL 2005 step by step install doc
Hassan - 20 Feb 2007 4:40 AM - 4 messages
Is there any doc/link out there that shows the step by step instructions for installing SQL 2005 ? Thanks ...
Score Copy Database Wizard Throughput?
cc - 20 Feb 2007 2:37 AM - 3 messages
Ok, so I'm trying to use the CDW to copy a SQL 2000 db to SQL 2005.  The original is composed of 2 or 3 data files and 1 translog file, total of about 12GB.  I connected each server -- separate boxes -- to my internal network, ...
Score identifying bottleneck
PS - 20 Feb 2007 12:00 AM - 7 messages
I have a slow performing SQL Server machine and need to make sure that it is not something configuration based or odd about their server before telling the client they need to upgrade. The identical database (meaning backup and restore to another machine) runs fine on even the slowest machine I could ...
Score SQL2000- Import Problems: DB Structure OK but missing all data
Michael Reed - 19 Feb 2007 11:59 PM - 4 messages
I had a system crash. Reinstalled SQL2000.  Imported .mdf file to recover database, but none of the 15 tables have data, and I'm missing all 100+ stored procedures. In addition to finding the .mdf file, I also found another ...
Score Fulltext search miss records in select
Henrik Juel - 19 Feb 2007 4:31 PM - 4 messages
Running SELECT productid,productname from productsFullText where freetext (*, 'x2000') or SELECT productid,productname from productsFullText where contains (*, 'x2000') gives 1 hit. SELECT productid,productname from productsFullText where productname like '%x2000%' gives 7 hits. I use the english wordbreaker and the FullIndex is populated with all ...
Score URGENT! Failed to reserve contiguous memory
pbriggsiberia - 19 Feb 2007 3:08 PM - 4 messages
We have a SQL issue that occurs just about every 2 weeks and cannot seem to pinpoint it. We do use linked servers heavily but no cursors or variants. We have all of the latest SP's and hotfixes and still are receiving this error. ...
Score Improving performance
Dylan Parry - 19 Feb 2007 2:47 PM - 6 messages
Hi, I used SQL Server 2005 on my development machine, and whilst this machine isn't as powerful as the live server, it does at times seem a little slower than I would expect. So I've been wondering if there is ...
Score Need help with shrink huge size of T-SQL log file
jeffzhang44 - 19 Feb 2007 1:51 PM - 5 messages
We have about 36 GB Log file. However, I can not use DBCC Shrink to reduce the size because the Database is constantly hitted by DLL files. Is there a way I can shrink it without stop the SQL services? ...
Log shipping goes out of sync
Linked Server Problems
Getting Fixed Drives Total Space and Free Space
Next »