Server Info(Very Urgent)

Apr 17, 2002

Hello,

There is Production server with different Unicode Id and its standard edition, I need to build the server with same configuration of production server, Can anyone help me as to how to get all the info of the server

Thanks

Ekta

View 1 Replies


ADVERTISEMENT

Urgent - Need Info For Auditor !!!

Dec 17, 2004

I need information about all the users in the database for the auditor ASAP. He/She wants to know specifically which users have sa privileges. SP_Helplogins does NOT give me what I need. If you look under the Server Roles tab when you create a new user - this is the information that I need to be able to pull out via query to produce at a moments notice for auditing purposes. I will need to generate reports periodically. Does anybody have a script that can produce this information.
Any help would be greatly appreciated. I am currently surfing through scripts in various sites but haven't run across exactly what I need yet.
Thanks so much in advance for any help.
Nancy

View 1 Replies View Related

Is There A System Table With Timestamp Info Or DTS Job Info?

May 7, 2007

I want to be able to see when records have been added to a table. The issue is we have a DTS job scheduled to run every night. The developer who wrote it password protected it and doesn't work here anymore. I want to add a step to this series of DTS jobs and want to run it just prior to his job. Is there a way to see when the records are being added or when this job is being run? Thanks again, you guys are the best.

ddave

View 3 Replies View Related

URGENT.Sql Server Does Not Recognise MAPI , Or Profile Name URGENT

Oct 26, 2000

hi, I have settup up sql mail and did the following:
1. created an E-mail account and configured Out look by creating a pop3 mail profile. tested it by sending and receiving mail, that is ook
2. I Created one domain account for MSsqlserver and Sql Agent service. both services use same account and start automatically in the control panel-services
3. I used the profile that I created in outlook to test the sql mail but got an error:
Error 22030 : A MAPI error ( error number:273) occurred: MapiLogon Ex Failed due to MAPI
Error 273: MAPI Logon Failed

I really do not know what went wrong. I followed the steps from bol and still having a problem. Am I missing something.

I do have a valid email account
I do have a valid domain account
I tested outlook using the email account and it worked. so why sql server does not recognise MAPI.

My next question, How to configure MAPI in Sql server if what I did was wrong.

View 1 Replies View Related

Urgent, Urgent !! My Sql Server Refused To Start Due To Encrypton

Mar 23, 2001

Hi, I have 2 windows 2000 server in cluster with sql server 2000 enterprise edition installed.
I have activated the Server-Requested Encryption by using the sql server network utility (Force Protocol Encryption). After this, I have stoped sql server service. But I can't start it at this moment.
The error is:
19015: The encrypton is required but no available certificat has been found.

Please help me to start sql server.

Thanks.

Michel

View 4 Replies View Related

I Need Some Info On MS SQl Server 6.5

May 7, 1999

Respected Sir,

I am from India. My office has 15 location all over India. I am in corporate office.We have Ms Sql server 6.5. Also all other centers have
have same Ms Sql Server 6.5. We develop a Intranet based application.
In which Ms Sql Server 6.5 is the back end and Netscape browser is the front end.

The centers have their independent database. all also have different data structurre.
But the Head Office needs data from them. How the replication technology help us. and How we we will conect through internet or we haveto have seprate dedicated
leased lines back to centers.

What will be data structure .

Himansu

View 1 Replies View Related

Sql Server Info

Mar 3, 2005

Hi All,

What is similar to "Schema" and "Table space" in SQL Server?

What is the physical organization/structure of SQL Server?

Thanks in advance,
Jai

View 7 Replies View Related

Some Info On MS SQL Server

Mar 1, 2006

I have developed a great intrest in the MS SQL Server recently. I was just wondering if it was worth putting my time into learning this system. In the members opinion would SQL server be technically fit? Does it have a good campacity and flexibility? These areas are quite important to me. I would also like to know how web friendly the server is and its ability to handle complex data.

Any help would be much appriciated.

View 2 Replies View Related

SQL Server Catalog Info

Sep 29, 2004

I am building an intranet application for my company .. similar to code generator

I am developing ASP.NET Application for this

1) How do I display list of SQL Server on the Network

2) Once I have list of SQL Server, I asked user to select once of the Server, provide credential for that server and obtain list of Database for that Server

3) Once I have list of Database, I need list of table under particular database

How do I do this in ASP.NET Application ?

View 2 Replies View Related

What Info Should A SQL Server Audit Contain?

May 13, 2006

That is to say, from a management perspective? I've been asked to provide one, as I'm the first DBA there ever, but I'm not sure what depth of info they want. And, does anyoe have scripts that can perform the audit, or an actual example audit?

I'd imagine an audit should encompass the following:

Database names;
Database sizes;
Location and size of data/temp/log etc. files;
Hardware specs (cpu/memory/disk sizes);
Number of logins;
User applications.

I'm sure that's only the tip of the iceberg, I'd be grateful for your input!

Thanks in advance,


Jaybee.

View 4 Replies View Related

MS SQL Server - LOCK Info

Feb 25, 2004

Hi

The system tables syslocks,syslockinfo give information on locked resources, spid, object_id,lock mode, lock status etc.

How will i get object_name

for example if a table is being locked above sys tables give object id, how can i get the actual table name ( object_name)

Please let me know
Best Regards
THNQdigital

View 4 Replies View Related

Sql Server As DDBMS, Where Info ?

Jul 20, 2005

Where can I find any materials about models of distriubution of data in sqlserver ?Any help will be appreciableGawel

View 2 Replies View Related

Basic Info Needed On SQL Server

Nov 10, 2000

I'm wanting to start to understand SQL Server. I've got the Beta Version of MS SQL Server 2000 and was wondering whether I could install this on my Windows Me box and start developing? Is this wise, or should i not use the Beta version? Is there a time when the Beta version "runs out"?

Are there any good basic SQL web sites out there? I know all about Access developement and i know some SQL, but i know nothing about SQL server. Which is the best site for me?


Thanks.

View 1 Replies View Related

Info On MAS90 / MAS200 For SQL Server

Jul 20, 2005

I was looking thru the mas90 info site ofhttp://www.accountingsoftwareconsul...ng_software.htmfor detailed info on MAS 200 SQL server.There's some info on that page, but I need more.Is there any more detailed info anywhere else on that site, or anywhere else?

View 1 Replies View Related

SQL Server 2000 Edition Info

Oct 18, 2007



Can someone help me with the following... My SQL server disk says standard edition on it, my invoice for the license says standard edition (granted it's expired according the license site) but when I go to the machine and right click on the local DB properties it says it's personal edition...

I am confused how this can be.. Any thoughts ?

The only way I figured this out was because we kept getting the you have exceeded your limit of 8 concurent queries...

Thanks

View 3 Replies View Related

Info About Sql Server 2005 Everywere

Jul 31, 2006

Hi ,
I must to realize a database application for an Automation system consisting of a Industrial PC with Operative System microsoft windows embedded.

1° question: Is Microsoft sql server 2005 everywere compatible for Microsoft windows embedded?
(I ask this because in specific of its is not clear)

2° question: In the case that it's compatible, if I instal it in a industrial Pc can it to act by database server or necessity of a remote server?

Tanks

View 1 Replies View Related

SQL Server 2000 And Transaction Log Error - More Info

Jul 20, 2005

Hi All:I am getting an error when trying to open a recordset in SQL Server 2000.The error states that the transaction log is full. Is there any way I canclear out or empty the transaction log, or get rid of it alltogether as itis not really needed?Any help would be appreciated.Thanks and regards,RyanThe error msg is: tempdb transaction log is full. B/U transaction log tofree up space..."

View 2 Replies View Related

Info On Data Replication On Sql Server 2000.

Jul 20, 2005

Hi,I'm in need of detailed information on how data replication works on thesql server 2000. If someone knows about a book or articles thatdescribes how data replication works with transactions, storedprocedures and/or merging databases I would like to be pointed in theright direction./Zero_Addiction.

View 1 Replies View Related

Need SQL Server Failover Cluster 2005 Info

Apr 16, 2008



Hi all,

I need some help to known more about basics of SQL Server 2005 failover cluster . pls provide me link to
known the concept.
Thanks,
Nav

View 6 Replies View Related

Using Triggers To Get Recently Updated Info In SQL Server 2000

Sep 30, 2004

Hello all,

I am trying to change values of two tables in my sql server 2000 database. When one of the tables is modified in some way like adding/updating a record, I need a trigger procedure to copy this new data from the first table to the second. Problem is, how do I get the newly inserted or updated data from the first table? How do I specify that I only want the data which caused the trigger to execute? Anyone know?

Thanks,
Bob

View 1 Replies View Related

Where Can I Find Info About How To Backup Sql Server 2005 Using A .bat File?

Aug 30, 2006

Where can I find info about how to backup Sql Server 2005 using a .bat file?

Is it possible doing it this way?

If so, can anyone direct me to some links how how to do this?

If not possible using a bat file... then how can I make schedueled backups? What tool to use and hopefully free.

View 2 Replies View Related

How To Define Configure Info While Deploying On Remote Server?

Mar 19, 2008

I use MSSQL Server to store the configure info and create deploymentutility to deploy the package on remote server,
If the configure info could be created automatically while deploying?
or I have to create the Table on remote server to record the configure info in manully?
Thanks a lot

View 1 Replies View Related

Process Info (SQL Server Enterprise - Management - Current Activity)

Jul 23, 2005

Dear AllI have problem with my database server which running SQL server 2000.The server running very slow. The worst case, to save a record requiredmore than 20-30 seconds.Since this problem, I usually monitoring Process Info from EnterpriseManager (Management - Current Activity), and I found a misteriousprocess as follow :1. User: SystemAccessTo: MasterStatus: BackgroundCommon: Task ManagerWaiting: >438 Million2. User: SystemAccessTo: MasterStatus: BackgroundCommon: Task ManagerPhysical IO: > 510003. User: Administrator (Join domain)Database: MSDBStatus: SleepingCommon: Awaiting CommandApp: SQL Agent Alert EngineCPU Usage: > 16 MillionAnybody know about these condition? Does it normal?ThanksMichael

View 3 Replies View Related

SQL Server 2012 :: Query Pulling Latest Info Data From Table

Aug 29, 2014

Let's say I have a table of data as per the below..

I'm trying to extract only the green highlighted items..

The rules applied are: Only the latest data concerning all cases, and only 1 line (the latest) per case.

As you can see in the image, I don't want the 2nd,3rd, and 4th record extracted cause they are all superseded by more recent records (identified as they are further in the table).

I've considered using either Distinct or Having? but can't get that to work.. If I could use Distinct but then ensure it's the latest record in the table that would be perfect.

View 7 Replies View Related

SQL Server 2014 :: Change Daily Info To Weekly Periods In Pivot Report

Sep 25, 2015

I create a report base on categories and sales of goods. Now I have Daily Info about all Products.

But I Need to present this report base on weekly periods. in pivotal format.

I family with pivotal format but change between daily report and weekly report is ambiguous for me.

View 3 Replies View Related

SQL Server 2005 Reporting Svcs - How To Use Dataset 1 Info To Drive Nested Table Select

May 20, 2008

I've only been doing sql 2005 for a couple of months with minimal training so there's a lot I don't know.
What I'm trying to do is load a nested table (industry & customer totals) based on a value from the table it's nested in.
This is the relationship of the data.
I have at the highest group, an industry code, then a customer, then the part and then the fiscal year.
What I'm trying to accomplish is to get a group total (footer) for the (1) industry code and (2) the customer code. This footer would contain the fiscal years (ascending) and their monthly totals. I would like to take the industry code from table one and pass it to the select statement in the dataset that feeds the nested table. I've read this is not possible to load a dataset field into a parm but I've seen where some people know how to work around this. If you reply, please explain in simple terms. Thanks!


industry Customer Year OCT NOV DEC
001 - Signposts
M12345
Part 1
2006 5 6 2
2007 0 3 1


Part 2
2006 4 3 0
2007 1 0 7

Customer M12345 totals
2006 9 9 2
2007 1 3 8


M45678
Part 3
2007 8 4 7
2008 3 4 8


Part 4
2006 3 8 7
2007 5 6 6


Customer M45678 totals
2006 3 8 7
2007 13 10 13
2008 3 4 8
Industry 001 totals




2006 12 17 9
2007 14 13 21
2008 3 4 8

View 1 Replies View Related

Timeout Expired -- URGENT, URGENT, URGENT!!!

Sep 27, 2000

This morning I can not connect to our SQL Server 7.0 whatever from client or server. The error message which I list below:

++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++
A connection could not be estabished to server--Timeout expired
Please verfy SQL Server is running and check your SQL Server registration properties and try again.
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++

We use windows NT authentication. We did not do any change on NT. The SQL Server daily schedule job usally stoped at 10:00AM, but today from the Window NT Task Manager, we can see that the SQL Server is still running untill now.

Please help!!!

View 3 Replies View Related

How To Get SQL Server Info(Version/SP Version/Server Statistics) From A Network.

Jul 23, 2005

Does anyone know how to get SQL Server versions, Service pack versionsand the Server that instance of SQL is running on a network. I haveseen some threads on how to list SQL servers in a network but I need tofind more info about these SQL servers.Any help appreciated..!Thx...

View 1 Replies View Related

Urgent Urgent Please.(Access SQL Pass Through Queries)

Jul 6, 2000

Hello,
I am facing a huge problem in my sql server database using access as a front end.The main problem is trying to execute queries "views" ,since they reside on sql server now,and using variables or parameters in reports and forms to filter on this query.
Ex.
how can the following be implemented using the same query but in sql server?
Access
------
SELECT MAT_Charts.YYYYMM
FROM MAT_Charts
WHERE ((([Area_Code] & "-" & [GROUP_CODE])=[Reports]![MAT_Chart_C1].[MAT_Key]))
GROUP BY MAT_Charts.YYYYMM;

It is specifically this statement in which I am interested:
[GROUP_CODE])=[Reports]![MAT_Chart_C1].[MAT_Key]))

Thank you very much for your concern.

View 2 Replies View Related

Server Up (Urgent)

Dec 4, 2001

Hello,

USE master

GO

SELECT a.*

FROM OPENROWSET('SQLOLEDB','Server1';'sa';'password',

'SELECT * FROM master.dbo.sysdatabases ') AS a

if @@rowcount <> 0
print' failure'
If @@error <> 0
print 'failure'

The server is down and I want it to print failure
but it don't goes to if statement but gives


Server: Msg 11, Level 16, State 1, Line 2
General network error. Check your network documentation.

Is there a way I could let it go to if statement, Or anyother way
to check that the server is down

Thanks

Rea

View 1 Replies View Related

Server ( Urgent )

Feb 22, 2001

Is there a way in SQL 7 ( NT ), one can allocate how much CPU time to be
used for a big query or a job, so others can work and not feeling much of
performance hit ? Looks to me when a query is submitted, server used all of
available resources and slow down other user requests.

Thanks for help.

View 1 Replies View Related

Sql Server 2000--urgent

Jun 16, 2007

i want to create fulltext search for that i have started Microsoft Search component but when i am tring to open SQL server Enterprise manager, i am getting sql server group but it showing "no items" not any database or any other data. what to do.

please help me out.

View 1 Replies View Related

Urgent Configuring Sql Server

May 29, 2008

hi all i try all date convertion  function that u imagen   in my asp.net project to insert a date  to sqlserver datetime field but always sql server get the data as "1/1/1900 00:00:00"
how can i fix that from sql server
plz

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved