Sponsored Links

microsoft.public.sqlserver.server microsoft.public.sqlserver.server

Page 8 of 1157

Threads in Forum : microsoft.public.sqlserver.server

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
help with a query... I need to create a complex query which gets data from 3 SQL tables. Table 1 - Department Dept_Id (int) primary key Dept_Name ... RAB	08-17-2010 07:16 AM Iain Sharp	1	19
SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS Hi, We have a large number of SQL 2000 databases having collation SQL_Latin1_General_CP1_CI_AS. We are now upgrading to SQL2008R2. I know that the... JimLad	08-17-2010 05:29 AM JimLad	3	13
How to get the Logical file name of a number of databases. I would like to restore a number of databases with a script similar to the following script. (SQL server 2000 version). RESTORE DATABASE ... ben brugman	08-17-2010 04:50 AM ben brugman	1	15
I: Win 7 and sql2000srv Dear ALL, I'd like to know if anyone of you experienced some troubles between sql2000 srv and windosws 7 clients to the other side , or if you know... Alberto	08-17-2010 03:08 AM Alberto	0	22
Log is out of space Hello, I'm running SQL Server Developer edition on Windows 7 Ultimate. Suddenly I cannot start the SQL server anymore. If I start the... Peter Afonin	08-16-2010 08:44 PM Peter Afonin	3	20
Cannot delete a user due to reference by object Managefactorstate Hello everyone, I restored a db from SQL 2000 into SQL 2008. I cannot delete a user, called tester', from Testdb-->security-->users. Error msg is... The Corleones	08-16-2010 06:50 PM Dan Guzman	2	16
Shrinking a transaction log file Hi, I am trying to better understand how and what happens when shrinking a transaction log file. We use SQL Server 2005 and I have been asked... bcap	08-16-2010 04:31 PM Erland Sommarskog	3	21
Linked Server Problem Hi there, I am trying to add a linked SQL 2000 server from SQL 2008 Management Studio. Using the native provider, it connects OK, but then when I... Waldy	08-16-2010 01:10 PM Erland Sommarskog	3	20
SQL Trace: "Normalizing" TextData Column Values to Obtain "QuerySignatures" for Hashing Hi All, The TextData column in a SQL Trace table will contain a distinct string for any invocation of the captured SQL statement that was invoked... Behzad Sadeghi	08-15-2010 08:28 AM Andrew J. Kelly	1	20
Dynamic SQL: Obtaining the Query Plans through DMV's? Is there a way to construct and run a Dynamic SQL query, and then, immediately afterwards, use DMV's to obtain its Execution Plan from the procedure... Behzad Sadeghi	08-15-2010 05:09 AM Behzad Sadeghi	2	17
Move data from one server to another We are trying to move some databases from a set of old servers to a new servers and they are pretty large.. like around 100 databases and... Raj	08-15-2010 04:51 AM John Bell	4	18
SQL 2005 SSAS license Hi. Is SSAS a part of SQL server 2005 license or we need to purchase it separately? Thanks, Mecn	08-13-2010 10:39 PM Dan Guzman	1	16
Ceckpoints in SQL 2005 Does sql server maintain a view containing info on checkpoint activity? Like when the checkpoints took place and how long they ran. Thanks in advance RG	08-13-2010 05:11 PM Erland Sommarskog	4	18
Impersonation Question Impersonation question I need to have a user (DOMAIN\USERA) connect to server01 using their own rights they already have by virtue of whatever... Toni	08-13-2010 04:19 PM Toni	1	18
SQL Server Service User Account Is there a reason why an account, having administrative privileges to the local machine, other than localsystem, should not be used to run various... RG	08-13-2010 03:04 PM Jeroen Mostert	1	23
How to delete .txt files from \Program+Files\Microsoft+SQL+Server\MSSQL.1\MSSQL\ LOG Hi All, We have SQL 2005 and would like to automate deletion of .txt files from \Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG folder. We have... hayko98	08-13-2010 02:20 PM hayko98	3	18
What does red cross icon mean beside server name in SSMS in sql 20 I am using sql server 2008. I just notice there is red cross icon beside server name in SSMS. Can anyone tell me what it means? Thanks Iter	08-13-2010 11:51 AM Iter	2	24
@@VERSION Gives Different Info Than Enterprise Manager (SQL 2000) Hello, We have a server running SQL Server 2000 running on Windows Server 2003 R2. When I run "select @@version" in Query Analyzer, I get the... JohnJohn	08-12-2010 05:01 PM Tom Cooper	1	20
help with a query... I have three tables Table1-Dept Dept_Id int (primKey) Dept_Name vchar Table2-Employees Employ_Id int (primkey) Dept_Id int... RAB	08-12-2010 11:44 AM Amol Lembhe	2	20
Database-Level Roles documentation in BOL All, Looks like there is a typo that I noticed while preparing a SOX document. The Sub section says "Working with server-level roles" but it... rgn	08-12-2010 09:12 AM rgn	2	20
Large Log File Hello, i have a replicated database (3 GB) with a log file that grown to 38 GB. The recovery Model is simple. DBCC Shrinkfile doesnt works. DBCC... Nighthawk	08-12-2010 07:10 AM Sandy	2	17
Stats assessment, accurate? -In SQL2005, it is OK to have older stats provided the table has not changed. How old is really older for optimizer or it doesn't care as long as... Bero	08-11-2010 03:57 PM Erland Sommarskog	1	20
Remove Duplicate Rows Hi. I want to remove duplicate rows from a table in sql server 2000. Let I have a table1 with a column name which have duplicate... Muhammad Bilal	08-11-2010 01:38 PM SQLDeveloper-Sonia	5	70
What does Profiler/Perf Monitor tick marks represent? Hi all! I am correlating my SQL profiler trace file with Perf Monitor csv data. When I import the performance data, I see the left side of the line... Mitchell_Collen via SQLMonster.com	08-11-2010 12:56 PM Mitchell_Collen via SQLMonster.com	0	22
How to set locks to 0 HI Under SQLServer2005 Advanced Properties - Parallelism, I need to set Locks to zero (0) because I suspect that 5000 locks that it shows actualy,... LAM	08-11-2010 11:16 AM LAM	2	19
Weekly Maintenance Plan Hello: The weekly maintenance plan that runs every week on Sunday morning in SQL 2005 failed for the first time in two years. The SQL error log... childofthe1980s	08-11-2010 06:26 AM childofthe1980s	4	17
Large log file Hello, i have a replicated database (3 GB) with a log file that grown to 38 GB. The recovery Model is simple. DBCC Shrinkfile doesnt works. DBCC... Nighthawk	08-11-2010 04:13 AM Nighthawk	0	36
Sql Server 2000 restore to different db name? Hello how would I restore a db named example 'UserDB_restore' from it's main db name backup file 'UserDB.bak'? I'm trying to simply restore it side... .	08-10-2010 03:56 PM .	2	19
SQL 2005 Oddities Hello: We have had SQL 2005 (9.00.4053) installed and running without issue for almost a couple of years. Today, I found a couple of... childofthe1980s	08-10-2010 06:14 AM childofthe1980s	2	20
SQL Server2K5 set up maintenance jobs across multiple instances? I have one one DBA audit database at one of the instances and looking at a possibility of setting jobs (row counts, checkdb, etc) across multiple... Bero	08-09-2010 06:00 PM Bero	0	18
Database 32-bit on win 64 Hi, Is a database 32-bit certified on a win 64-bit OS It seems not but the certification matrix is not clear about tis have you any clue ? Thanks bob123	08-09-2010 02:49 PM bob123	1	17
alter column - changing nullability A variable length column need to change its nullability property: alter table T alter column c varchar(5000) not null; The length of 5000 is not... Lars Tafjord	08-09-2010 02:46 PM Erland Sommarskog	2	18
How to put an "mdf" file into 2 different physical drive? Hi, i need help. I have a server HP G6, with MS SQL 2008 installed on it. My "Drive C" is almost full. My "database.mdf" dan "database.ldf" is on... harifajri@gmail.com	08-09-2010 02:26 PM Erland Sommarskog	1	21
SQL Server 2008 R2 Native Client backward-compatible to SQL2005/2008?? We have several different SQL Server versions in our datacenter, with SQL Native Client 9.00.1399.06 on our Citrix servers. The above SQL Native... tom12010	08-09-2010 12:39 PM tom12010	2	22
data analyst job profile i searched a job in sql server but i got a job as data analyst in one bpo. The work was like just copying and pasting the sql queries. I want to... evergreenyellow_20008	08-08-2010 10:45 PM Jabran	2	21
select with subquery in select clause Hi I need to make a select from 2 tables whit this layout always with the newest datetime exchange currency. The local cuurency is Mexican... jrchaveztj	08-07-2010 01:57 PM Erland Sommarskog	1	18
select with subquery in select clause Hi I need to make a select from 2 tables whit this layout always with the newest datetime exchange currency. The local cuurency is Mexican... jrchaveztj	08-07-2010 12:10 PM jrchaveztj	0	20
get number of monday, tuesday,... between 2 dates Hi, how can I get number of monday, tuesday,... between 2 dates? Thanks, Racsus	08-06-2010 01:09 PM hayko98	3	19
Report server setup for multiple applications We are trying to build a consolidated Report server environment that should fulfill all the requirements for different application. We have... sm	08-05-2010 05:20 PM sm	0	24
How much memory should be free on a Server with SQL Server installed? I am the new DBA in a company and I see that their production server has between 90 and 95% of memory been used. The problem is that according to the... Abraham Ocón C.	08-05-2010 04:28 PM Erland Sommarskog	2	20
Auto Update Statistics We are running SQL Server 2008 SP2 Enterprises. We have a table with a column that identifies individual clients, such as Client_UID, which is an... cbrichards via SQLMonster.com	08-05-2010 01:59 PM Erland Sommarskog	1	22
Pages for Database's Indexes. What is a way to get the number of pages for each database's tables and indexes, so I can see all the number of pages and size. Just trying... Hoardling1 via SQLMonster.com	08-05-2010 02:07 AM amish	1	24
Backups I created an incremental backup of one of my databases and set it to backup every hour as a test. It's on SQL Server 2000. How do I stop it. It's... Matthew	08-04-2010 03:46 PM Matthew	2	23
Primary records with dependent as columns I have a query to fetch primary with all dependents that gives me result as: ID Primary Name depId DepName Dep DOB 10 Liselotte... Dotnet Developer	08-04-2010 02:46 PM Erland Sommarskog	1	18
linked servers between different sql versions?? Can a SQL Server 2008 server have a linked server that is SQL Server 2008 R2?? We presently use a SQL Server 2008 for reporting which links to a... tom12010	08-04-2010 02:39 PM tom12010	4	22
SEarching for records with unwanted unicode "blob" in text Hi We have an unknown number of records which contain a Unicode (65533) character in a text address field. Ie a "ï¿½" We need to removed these... mike.kolling@gmail.com	08-04-2010 08:21 AM Mike	3	17
Decode XML Data Type I have something like the following: declare @msg xml set @msg = '<Message><SubItem>Some Text</SubItem></Message>' I'd like to be able to extract... Charles	08-04-2010 07:59 AM Charles	4	12
Batch File ??? Hi. Is it possible to provide Server Name, Username and password at run time instead of writing it in the batch file? Regards, Muhammad Bilal Muhammad Bilal	08-03-2010 04:08 PM John Bell	1	25
return null for the column column_default in the view sys.informat Hi Guys I have a id that has dbreader role. When I use this ID to run the query select * from sys.information_schema.columns, the column... Iter	08-03-2010 02:35 PM Erland Sommarskog	2	22
Cascade delete Hi, I need to find out if the cascade delete option is set on any of the tables in my database. Any help is greatly appreciated. Cheers Mounilk Mounilk	08-02-2010 09:53 PM Tom Cooper	3	21

Page 8 of 1157

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off