Prerequisites For Bcp Usage
Dec 30, 2006
2 questions pls:
1/ can we use bcp also in windows authentication mode or only in sql server mode.
Because when i try to execute bcp from dos using windows account (my machine account since m runing XP) I get the error:
The user is not associated with a trusted SQL Server connection
but when i switched to sql server authentication mode. the new username and password worked well when used in BCP from command prompt.
so my question: how do i make bcp work when using win auth mode instead of sql auth mode
Thanks a lot
View 3 Replies
ADVERTISEMENT
May 9, 2008
What are the minimum requirements for setting up replication ?
i mean, the connection requirements, bandwidth requirements, minimum hardware and software requirements ?
Is it possible to setup a replication across the internet ?
View 2 Replies
View Related
Mar 28, 2007
I have a script which creates a new user. I also have a webpage which uses the DB for various reasons. In the DB config file I use the following to connect to the DB;
<ConnectionString>User Id=<username>;Password=<pword>; DataBase=<DBname>; Server = <servername>;</ConnectionString>
For the username and password I use the newly created user information but I can’t connect. However if I use “sa� to login I have no problem. Is this a case of some crappy SQL prerequisites?? i.e. automatically checking “Enforce password expiration� or “user must change password at next login� in the user properties. If I change the password for the new user in properties I can connect no problem.
Is there a way around this, so I don’t have to change the password before I can connect to the DB?
Thanks in advance
Regards
Toby
View 1 Replies
View Related
Mar 28, 2007
I have a script which creates a new user. I also have a webpage which uses the DB for various reasons. In the DB config file I use the following to connect to the DB;
<ConnectionString>User Id=<username>;Password=<pword>; DataBase=<DBname>; Server = <servername>;</ConnectionString>
For the username and password I use the newly created user information but I can€™t connect. However if I use €œsa€? to login I have no problem. Is this a case of some crappy SQL prerequisites?? i.e. automatically checking €œEnforce password expiration€? or €œuser must change password at next login€? in the user properties. If I change the password for the new user in properties I can connect no problem.
Is there a way around this, so I don€™t have to change the password before I can connect to the DB?
Thanks in advance
Regards
Toby
View 3 Replies
View Related
May 11, 2007
Hi!
I want to deploy an application that require the SQL Server Compact Edition 3.5 to be installed..... and I want to deploy my application with ClickOnce!
But, the problem is that I can't select "SQL Server Compact Edition" in the prerequisites of the Visual Studio Project properties... ???
Do you have a solution ?
thx!
View 1 Replies
View Related
Feb 15, 2008
I marked previous post as answered but I'm having another problem now.
The previous problem was that I didn't have some prerequisites. The log files say:
**************
Report Designer component requirement
<B>Explanation:</B> Visual Studio .NET 2003 is not installed.
<B>Action:</B> Install Visual Studio .NET 2003, and then rerun Setup to install Report Designer. Or, continue Setup to complete the installation without Report Designer.
Report Server component requirement
<B>Explanation:</B> ASP.NET version 1.1 is not installed or is not registered with your Web server. ASP.Net is required for the Report Server and the Report Manager components.
<B>Action:</B> Install ASP.NET 1.1, and then rerun setup to install Report Server or Report Manager components. To use the Report Server component, ASP.NET 1.1 must be registered with your Web server. Or, you can continue Setup to complete the installation without these components. For more information about ASP.NET requirements, see the Reporting Services readme file.
Report size = 1082
<Func Name='SetDotNetProperties'>
<Func Name='FSetupLogging'>
<Func Name='CreateSetupLogCabs'>
Creating Setup Logs Cab "C:Program FilesMicrosoft SQL Server80RS Setup BootstrapLOGRSStp_.cab"
The thing is that in the ADDLOCAL section of template.ini I didn't include Report Designer.
ADDLOCAL=RS_Admin_Tools,RS_BooksOnline_EN
Is Report Designer needed for the administrative tools and the books online? Or is that this too components need those prerequisites too? I ask because I installed manually without thos prerequisites, and it gave me no problems.
Thanks a lot once again!
View 4 Replies
View Related
Jan 4, 2007
Hi
I need this script to work on any instance:
exec master..xp_cmdshell 'bcp mosaikDB741.dbo.FilelistInput in csvFilePath.csv -t -c -userName -Ppassword -Sinstance'
Can I customize it more in order if someone runs it on a different instance or server it won t fail. All he will need to replace is the username, password and make sure there is mosaikDB741.dbo.FilelistInput table and csvFilePath.csv file
Thanks a lot.
View 2 Replies
View Related
Sep 4, 2015
We have a SQL 2008 Instance existing on active/passive cluster with 2 nodes running on Windows server 2008 R2 Ent. Edn.
Now we need to install another SQL instance on this cluster. So what are the prerequisites apart from new IP address? Do we need shared disks or can the existing disks can be utilized?
View 3 Replies
View Related
Nov 2, 2007
I have a client program that writes to sql server database 10 records per second . i want to compute the CPU usage and the memory usage for the whole program or CPU usage,memory usage for the insert statement in the program .
Can anybody help me with this?
View 6 Replies
View Related
Sep 7, 2007
Hello, When I am seeing SQL Server 2005 Management studio Server Dashboard> I am seeing my(USERS) databases and msdb database usage is very small % of in CPU Usage(%), Logical IO Performed (%) Usage pie chart.
90% of Total cpu usage is showing for Adhoc Queries. what excatly this means in Dashboard? if application uses more than it would have shown in Database level or not?
sicerely this dashboard is good, if any one is watching daily, please advice their experiences here.
Thanks in advance. Hail SQL Server!
View 3 Replies
View Related
Jan 30, 2014
providing a query for fetching the data for CPU Usage, Memory usage, blocking and all details ...
I want to create a job which will run on a Node every 15 min and store data in a table for each instance...
DMV is not giving more stuff and xtended events not sure if i can store that data into a table?
View 7 Replies
View Related
May 9, 2001
hi there,
i need to transfer the data off a query output to a txt file in the same order as it prints. i have tried using the command
eg.
exec bcp "SELECT au_fname, au_lname FROM pubs..authors ORDER BY au_lname" queryout Authors.txt -c -Sservername -Usa -Ppassword
this is exactly what i used replacing the appropriate parameters, but it gave me a "syntax error near queryout"
PLEASE advice what is wrong or sugest the best method to achieve the same.
Any help would be appretiated.
Thanks,
c: )
View 2 Replies
View Related
Feb 15, 2000
I need to provide some infomation on how much (trans/request)SQL7 can handle.
I checked the white papers and testimonials, but don't see any actual numbers.
We have a clustered SQL7 environment sitting on some Compaq 6400 using 4 cpu's. Our database size is only about 3.5 gig and we are using IIS 3. Does anyone know where to get this information?
Please advise
Thanks
Susan
View 2 Replies
View Related
Jun 6, 2003
Hi,
We have a SQL Server 2000 Enterprise Edition running as production
The CPU Usage is High when there were >350 user connections.
The buffer hit ratio is good. I checked all the monitor.
Can anyone can guide me why it is causing.
Thanks in advance,
Anu
View 8 Replies
View Related
Dec 1, 2004
Hi guys, I have a sell server its a new server 4 processors and 4 gigs of ram. SQL server is pinning the CPU's 100% I can’t figure out why, I'm at mdac 2.7 with the hotfix. I don’t know what else to look at.
Any ideas?
View 1 Replies
View Related
Apr 20, 1999
Hi .... I'd like to know if I can use BCP to transfer the whole database to a device or file and then back to the server(I mean,using only one server) with a new char set/sort order configuration,or I have to do it table by table??? How do I use BCP to perform this task?What commands and parameters should I use???
Thanks for your attention,
Luciano
View 1 Replies
View Related
Sep 15, 2004
we have CPU Usage upto almost 100% i increased the tempdb, and master to almost double the size
then we increased the memory to high amount.
does anyone have suggestion pls help since it running too slow, since we did an upgrade
View 8 Replies
View Related
Apr 22, 2004
I have a SQL 2000 Server, dual processer with hyperthreading. 2Gb of Ram. The machine is only being used as a SQL Server
Normally the server runs at about 15-20% usage. I have now noticed a problem where the SQL server suddenly jumps to 100%, this can happen after a week or a couple of days. It requires a server reboot to fix the problem. Stopping the SQL server and restarting will not work.
I don't know if this is part of the problem, but I have noticed that after a day or so the processor usage climbs by about 10%, if I stop the SQL service and restart, the processor usage drop by the 10%.
Also I have set the memory usage to be 1.5Gb, but it takes a day or two for the SQL server to consume this amount of memory. Don't know if this has anything to do with it.
Anyone know why this is happening ?
Kev
View 5 Replies
View Related
Aug 30, 2005
Hi All.
I am new to MSSQL, Iam using it to store largeamounts of data on a daily basis,that I import from a CSV file at the rate that I am going it should be about 1Gig a month of data. I noticed that as I add data to MSSQL my ram usage climbs by the size of the data. Is there someting Ihave done wrong inthe setup.
Thanks
Scott
View 11 Replies
View Related
Apr 4, 2007
I've got a copy of SQL2005 and IIS on the same machine. Sql Server seems to be eating a lot of RAM, eventually causing IIS to restart.
Anybody had any luck playing with max server memory ?
View 1 Replies
View Related
May 7, 2007
hi all,
when I click web page (executing some stored procedure generally will take less than 2 minutes) the CPU usage is becoming 100% and taking a long time to run.I already posted a forum before (SQL server 2005 running slow ). I dont know these problems are related.If I restart the server then it will run as ususal.What should be problem.Server Windows 2003 ,SQL server 2005
Is it bcos of any memory lekage or any other reason..
Thanks
leo
View 9 Replies
View Related
Nov 23, 2005
HiI am having a real issue with CPU usage by SQL Server, and it is notrelated to a poor query.I have a clients database that I am currently investigating some issueswith. After I perform a standard task using the application, and theresults have been returned to the application the cpu usage remains at100%.Even once the application has been completely closed down the cpu usageremains at 100%. Nothing else is happening.I am at a complete loss as to how to proceed to with investigation ofthis issue (i have been looking at this for over a week using SQLServer tools and Performance Monitor, and eliminating various otherpossibilities)I downloaded Process Explorer, and looking at the threads forsqlservr.exe there is one in particular that is consuming all of thecpu time:MSVCRT.DLLI am running SQL Server 2000 SP4 on the following machine:Windows 2000 SP4Pentium 4 3Ghz (Note this is seen as 2 processors so the reported cpuusage is 50%)1Gb MemoryI also have about 20Gig of free disk space.One other thing, the page faults reported on the Performance tab ofProcess Explorer exceeds 3 million. This is after running theapplication for around 10 minutes.Please can anybody suggest anything at all that might help? I'm sorrythere is not too much information in here but I have not been able tofind out anything useful!Many Thanks in advance.Paul
View 22 Replies
View Related
Jul 6, 2006
Hi guys,Got an odd SQL string that I need to produce that is most probably simple toconstruct but with it being hot in our office, I simply can't get my headaround it....!!Its based around an online emailing facility whereby multiple hotels can beemailed via a single application. Users within the application have accessrights to email only specific hotels.The tables are laid out like this (irrelevant columns left out)...CampaignID, CampaignName, CampaignHotelIDs1 Test Campaign 1,4,5,7,92 Test Campaign2 1,2UserID, UserName, UserHotelIDAccess1 Test User 1,6,72 Test User 2,7Now on the stats page I want to give users access to view ONLY sentcampaigns to which they have access to view, I was considering the IN SQLstatement to achieve something like this...'WHERE CampaignHotelIDs IN UserHotelIDAcess'....but that doesn't want to work, can anyone give me any ideas to get thisworking within just a single SQL query?Cheers, @sh
View 7 Replies
View Related
Jan 24, 2008
Hi,
I have 2 SQL Server 2005 instances in one server. We noticed that CPU usage is high in the server. Is there is any posibility to know how many percentage each SQL Server instances is taking?
LIke Total usage is 60%.
Instance 1 is 40%
Instance 2 is 20%
regards
Wilson Thomas
View 13 Replies
View Related
Aug 29, 2007
Hi all,
I want to write a backup application for SQL server.I have read the VDI specifications. I want to know whether I can use the VDI just to freeze and thaw without taking the snaphot and the backup. Or is there any other way to do the same ?
Thanks in Advance.
View 1 Replies
View Related
Mar 26, 2008
Good day to all,
I'm new here, so I don't know if this is the right forum to post my problem. I have a web application written using C# .net 2005 (W/ajax). The application has a module that uploads data from excel file to the sql server 2005 database. w/c is by the way, i'm using SQL 2005 Express Edition, the app can upload up to more than 10,000 records from an excel file. Everything is ok until it was deployed in a test environment, while having a run through with the system, the application encounter an error after which, we cannot log in to the system anymore. I restarted the server (web and sql server in 1 machine running winxp) then I can log-in again in the system. When I'm tracing where the problem came from, I noticed that the memory usage of sqlservr.exe increases everytime the app connects to the server. I already fix some code to close some objects that might have caused the high memory usage, then I run sp_who in the management studio and there are still connections used by the app AWAITING COMMAND. Then I manually kill (using kill spid) connection that are left opened by the application. But the mem usage of sqlservr did no decrease. Is there a way to release the memory usage of sqlservr.exe? In ASP.Net ? I have a hint that this has been causing the error. Thanks a lot.
View 4 Replies
View Related
Nov 25, 2001
Hi,
it seems that every day SQL Server 2000 has some kind of memory leak,
the memory usage creeps above 150000 approximately 3 times per day. Is this normal? It starts at about 13000.
Is there any way that I can monitor what is causing the memory usage to be so high and maybe rectify it?
Thanks for the help.
Steve
View 1 Replies
View Related
Jul 31, 2001
SQL takes all CPU resource on some of the intensive
queries. Is any way to make sure there is something left for other tasks
to be processed? Let's say limit SQL to use no more than 80% of CPU.
Thanks
View 3 Replies
View Related
Sep 5, 2001
For a given table:
Data 11.91 MB (37.76%)
Indexes 19.41 MB (61.57%)
Unused 0.21 MB (0.67%)
Total 31.53 MB
# Rows 299474
You can see that the indexes are taking up
more space than data there are a total of four
indexes on the table is shouldn't the data(MB) be
higher than the indexes(MB) ?
View 1 Replies
View Related
Sep 21, 2000
Does anyone know about this? Can you reassign package ownership to a group? For example, we use NT groups to manage SQL security. As such, the group is listed as a valid SQL Login. Can I change (reassign) ownership to this group? I tried it a few different ways but have not yet been successful (i.e. NT local group that contains a global group, local group that contains individual account(s)). Our global groups and user accounts reside in domain1 and the development server resides in domain2.
As for the purpose, unless I am the owner of a package, I cannot edit the package in DTS Designer and save it under the same name (new version). Some of our efforts require shared editting.
Thanks.
View 2 Replies
View Related
Aug 24, 2000
Hi all,
I need to drop some of my indexes to keep the size of my DB manageable. I know they're not all being used, but what is the best way to determine how often they are being used? Statistics? I haven't come across any text referring to this so any help is appreciated.
Pete Karhatsu
View 1 Replies
View Related
Dec 5, 2004
Hi,
I have managed to setup some cubes on the server, have roles defined, and users are using
these and the results are mathcing...
Is there a way that I can get some sort of user based usage log of the cubes andget details
of when and what type of data did any user see/make use of?
I'll appreciate any help in this regard.
View 2 Replies
View Related
May 10, 2006
I would just like to know what everyone uses to monitor SQL usage? We have a SQL 2000 server that already has several applications sharing it and everyone wants to keep forcing more onto it.
I want to be able to judge when this server has reached it's capacity or how much more it can allow. Can SQL profiler alone do this for me?
Thanks.
View 1 Replies
View Related
