|
ops
it didnt work ido all thing but the same problem occured
|
|
|
|
|
Have you enabled
Client Protocol > Named Pipes ?
|
|
|
|
|
services can be restarted by right clicking your sql server in Management studio and clicking on restart or from windows services (typing services.msc in run will open)
Best Of Regards,
SOFTDEV
If you have knowledge, let others light their candles at it
|
|
|
|
|
sorry for being late.......please tell me how to enable sql browser
|
|
|
|
|
in sql server configuration area
Sql server services
Best Of Regards,
SOFTDEV
If you have knowledge, let others light their candles at it
|
|
|
|
|
nothing else if you are connecting through Named Pipes then you should enable Named Pipes and if you are connecting through TCP/IP then you should enable your tcp/ip protocol , make sure your SQL Browser is also started....
Best Of Regards,
SOFTDEV
If you have knowledge, let others light their candles at it
|
|
|
|
|
Do you trying to connect SQL Server via a proxy server... please let me know.
I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.
Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you.
Thanks
Md. Marufuzzaman
|
|
|
|
|
You are using forward slashes throughout your connection string. Change them all to back slashes.
./SQLExpress should be .\SQLExpress
Your AttachDBFileName is C:/whatever/wherever/......... and should be C:\whatever\wherever\.........
If you do that all should work.
When you get an error message you should pay attention to what it says. The error message talked about the SQL Server. The only reference to the server was ./SQLExpress , so that is where you should start looking. Changing it, as I suggest would possibly have caused a different error (for the slashes in your path, although that might have worked, I haven't tested it). Always read your error messages carefully!
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
This is the most common problem when Database server couldnt be reached.
Check if you made firewall exemption to the SQL Server browser
|
|
|
|
|
Hi,
I am new to SQL and I am learning SQL through tutorials, Currently I am studying A topic named TRANSACTION.
its good to know that statements in the transaction can be ROLLED BACK if anything accidently goes wrong OR COMMITTED when every thing goes fine.
Then I read about choosing a proper storage engine is a must, but I cannot figure out what is a storage engine what does it do and which is best.
can anyone please help me?
|
|
|
|
|
You do not say which SQL Server you are using reading about, but I suspect that it is MySql, since that is the only one that I know of that has a selection of storage engines.
If this is correct, basically the different storage engines available are better suited to different types of application/data. You might be better off visiting the MySql site, specifically this page[^] as a starting point. Then just follow your nose.
[Edit]
1) fixed bad wording in first sentence.
2) Here is a link to stuff about the Storage Engine for SqlServer 2005. clickety[^]
[/Edit]
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
modified on Friday, September 11, 2009 6:53 AM
|
|
|
|
|
Hello
when i try configure sql server 2005.
SQL Server Browser to Configure SQL Server Express 2005 for Remote Access.
In Sql server Browser Properties.
Built in Account
I select Network Service.
When Apply These Changes
Following Error Occure:
"A member could not be added to a local group because the member has the wrong account type.[0*8007056c]"
Thanks
My email id=manish.m.meshram@gmail.com
|
|
|
|
|
What is the syntax for using a sQLParameter to insert a SqlHierarchyId. I'm stuck with the datatype to apply to the parameter object as I can't seem to get anything to support the SqlHierarchyId type. And my google mojo has completely let me down.
List<SqlParameter> lParams = new List<SqlParameter>();
SqlParameter oParam = new SqlParameter();
oParam.ParameterName = "@NodeKey";
oParam.Value = this.NodeKey;
oParam.SqlValue = this.NodeKey;
oParam.DbType = SqlHierarchyId;
|
|
|
|
|
By using a varchar datatype for the insert parameter. It seems there is an implicit conversion from varchar to hierarchyid in SQL Server 2008
oParam = new SqlParameter();
oParam.ParameterName = "@NodeKey";
oParam.DbType.Equals(SqlDbType.VarChar);
oParam.Value = this.NodeKey.ToString();
oCmd.Parameters.Add(oParam);
|
|
|
|
|
Hi,
I am trying to help my IT department by developing a simple vb.net app where I am going through EventLog on XP and Vista Boxes and uploading all EventEntries to a db hosted on MSSQL-Express.
The executable sits that sits on a client PC and is compiled as a console app that gets fired up through scheduled task.
My app attempts to insert new records for every record found in EventLog on each PC on the network to db at around noon (noon is the time when scheduled task fires up my app.). I have about 50PCs on the network and I use Procedure to insert new records.
My question is, how many simultaneous connections MSSQL-EXPRESS can handle and what happens when I attempt to insert into the same table from more than 1 client.
What would you recommend if I needed to increase number of workstations that upload to DB.
Appretiate your help and advise.
|
|
|
|
|
I don't know the format for the log files but would assume either fixed length or hopefully delimited.
I would use Bulkcopy (I assume express supports it) if the files are delimited.
Read all the log into a datatable in the client, bulkcopy the datatable to the database, run the process. I would expect the ETL to take less than 1 minute so would schedule the systems to fire at i minute intervals (this will be a PITA so have the client app use an identifier to decide the order and have the client wait #n minutes).
Another option, have your clients send the log files to a centralised folder. Another app (SSIS maybe) reads all files from the folder and loads then. This allows you to use BCP (even faster and supports format files for fixed length) and there is no possibility of a clash caused by multiple loaders.
Oh, SSIS is probably not in SQLExpress and BCP may not be supported.
|
|
|
|
|
|
A comparison of the various editions of SQL Server is given here:
http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx[^]
There is no limit to the number of connections for SQL Express, other than the limits imposed by the restriction to a single CPU and 1GB of RAM.
As far as inserting into the same table from more than 1 client goes, SQL Express is no different from any other database. Depending on what your application is doing (insert only or are any reads or updates involved?), the transaction scope you use (do you insert each row in its own transaction, or do you block the whole lot into one big transaction?) and what isolation level you are using (the default - read committed - sounds as if it should be OK for your application if it's insert only), you may or may not see blocking occurring between the clients.
What do you do if SQL Express tops out and can't cope with the load? Well, one answer is: put your hand in your pocket and buy a full version of SQL Server. If you don't have the budget for that, you could either look to use one of the free databases that are available (MySQL, Firebird, PostgreSQL, SAPDB, there are loads of them around) or you could think laterally. Don't run all the scheduled jobs at noon, stagger them through the day. Or don't write directly into the main database, write each clients' log into its own staging area then have a single central job which comes round and collates it all together later. Think of it as a chance to get creative and flex your architectural design skills.
|
|
|
|
|
You might5 find this[^] article on BatchSize useful.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Hello,
I have for example the following table
NICKNAME JOBNAME EQUIPNAME STARTTIME
SNB_A0_01_0719 051_A0_marbles_stress_AB_tie2vss post -FIB testing 2009-09-10 11:33:46.880
SNB_A0_01_0719 051_A0_marbles_stress_AB_tie2vss Post-FIB Testing Cabinet0 IS 2009-09-10 11:33:19.203
SNB_A0_01_0719 051_A0_marbles_stress_AB_tie2vss TESTING Cabinet 2009-09-10 11:34:13.233
SNB_A0_01_0720 051_A0_marbles_stress_AB_tie2vss post -FIB testing 2009-09-10 12:11:24.790
SNB_A0_01_0720 051_A0_marbles_stress_AB_tie2vss Post-FIB Testing Cabinet0 IS 2009-09-10 12:10:39.340
SNB_A0_01_0720 051_A0_marbles_stress_AB_tie2vss Pre-FIB Testing Cabinet0 IS 2009-09-10 07:58:20.937
SNB_A0_01_0720 051_A0_marbles_stress_AB_tie2vss TESTING Cabinet 2009-09-10 12:11:43.603
SNB_A0_01_0721 052_A0_marbles_stress_A_tie2vss Pre FIB Testing 2009-09-10 11:13:59.960
SNB_A0_01_0721 052_A0_marbles_stress_A_tie2vss Pre-FIB Testing Cabinet0 IS 2009-09-10 09:28:10.480
SNB_A0_01_0722 053_A0_marbles_stress_b_tie2vss Pre FIB Testing 2009-09-10 10:33:12.183
SNB_A0_01_0722 053_A0_marbles_stress_b_tie2vss Pre-FIB Testing Cabinet0 IS 2009-09-10 10:23:06.260
SNB_A1_00_0718 050_A1_DDR_Rx_Delay_pp Pre-FIB Testing Cabinet0 IS 2009-09-10 06:34:43.330
I need to choose distinct nicknames,jobnames and equipnames where the starttime is the biggest
for example for nickname SNB_A0_01_0719 i need only the 3rd row.
How can i do it?
|
|
|
|
|
Use a CTE with a Row_Number() partitioned over nickname, ordered by starttime desc with the appropriate where filter. From that select the record with row_number() = 3
|
|
|
|
|
Or:
SELECT * FROM TEST_TABLE
WHERE STARTTIME IN (SELECT MAX(STARTTIME)
FROM TEST_TABLE
GROUP BY NICKNAME, JOBNAME)
My advice is free, and you may get what you paid for.
modified on Friday, September 11, 2009 8:04 AM
|
|
|
|
|
select myDate
from myTable
where myDate > datediff(yyyy,now,myDate)=> 3)
I want to select date which is greater that now - 3 years(less than 3 yr.s old)
above query gives me following error:-
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near '='
|
|
|
|
|
got it
Posting it here if it might help anyone in future !!..
select myDate
from myTable
where datediff (yyyy,myDate ,getdate()) <= 3
|
|
|
|
|
select * from yourtablename
where
DateDiff(year, myDate, getdate()) >= 3
|
|
|
|