Friday, March 30, 2012
How can i restrict the SA user
Is there any way to restrict the SA access. The problem is that all my
client machine users knows the sa password, and also right now i don't want
to change the password. So i just want to know is there any way to restrict
their access ? thanking in advance
ARHi
SA is not restrictable as it is the highest built in security account.
If security is so important, you have to change the password. Remember, if
you are using integrated security, domain and local admins are by default,
mapped to SA.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Aneesh" <aneesh.r@.eostek.com> wrote in message
news:u4iPss30EHA.2608@.TK2MSFTNGP10.phx.gbl...
> hi,
> Is there any way to restrict the SA access. The problem is that all my
> client machine users knows the sa password, and also right now i don't
want
> to change the password. So i just want to know is there any way to
restrict
> their access ? thanking in advance
> AR
>|||"Aneesh" <aneesh.r@.eostek.com> wrote in message
news:u4iPss30EHA.2608@.TK2MSFTNGP10.phx.gbl...
> hi,
> Is there any way to restrict the SA access. The problem is that all my
> client machine users knows the sa password, and also right now i don't
want
> to change the password. So i just want to know is there any way to
restrict
> their access ? thanking in advance
> AR
Make a new user and give him an appropriate permissions.
regards,
Dra
Wednesday, March 28, 2012
How can I remote my sql server?
How do I get access to my server.
It keeps saying this.
I set yes to tcp
What port is it suposto be on?
Code Snippet
TITLE: Connect to Server
Cannot connect to gv.ns1.name.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476
BUTTONS:
OK
Verify that you have followed all the steps in these articles.
Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx
Configuration -Connect to SQL Express and ‘Stay Connected’
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html
Configuration - Guideline for Connectivity Question Posting
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1
So it has nothing to do with firewall.
Something in setting but i have no clue about this....|||Verify that the SQL Server is actually running. Check in the Services applet.|||I can connect though the computer.
Not though remote though.|||
So, if you can connect through the local computer, and not the remote computer, and you are certain that the configurations for remote connections are set correctly,
... and you say that you
can't connect even to localhost
what computer are you attempting to connect to remotely. (Clue: The remote computer is NOT known as 'localhost'.)
Please post your entire connection string.
|||Did you edit your lmhosts or hosts file? Doing remote connections, you need to resolve the IP address into a name.|||Can you verify that you followed the instructions in this posting. Quick check list:
Make sure that TCP/IP is enabled for the instance (Use SQL Server Configuration Manager) If using a named instance, make sure that the SQL Server Browser server is running (Use SQL Server Configuration Manager) If using a named instance and you're running a firewall, make sure sqlservr.exe and sqlbrowser are added to the exception list.Monday, March 26, 2012
How can I process each row in result set to access properties on another package o
properties based query that returns a scalar value. You'll need to specify
a separate query for each property.
Hope this helps.
Dan Guzman
SQL Server MVP
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:O4WyV0zSEHA.3332@.tk2msftngp13.phx.gbl...
> (SQL Server 2000, SP3a)
> Hello all!
> I have a DTS package that I'm working with, in which I have a query that I
want to invoke
> on a target SQL Server that will return a handful of rows. For each row,
I want to set
> some package properties (on another object in the package). What would be
the best
> approach to this? I thought that I might use the "Transform Data Task",
even though I
> don't really have a "Destination", per se (that is, I want to process each
"Source" record
> via an ActiveX script).
> However, when I try and do this, I seem to be getting an error when I
execute that
> "Transform Data Task" step (something akin to "Execution Cancelled by
User").
> Is there some other way that I should approach this?
> Regards,
> John Peterson
>Thanks, Dan -- but I can't seem to get my head around your suggestion. Basi
cally, what I
want is to be able to specify a Source Query that would return a bunch of ro
ws. Then, for
each row, I want to invoke some ActiveX snippet withOUT doing anything to a
"Destination".
I don't see that it's too easy with DTS...
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:u8ri%23s0SEHA.3608@.TK2MSFTNGP11.phx.gbl...
> Take a look at the DynamicProperties task. This will allow you to set DTS
> properties based query that returns a scalar value. You'll need to specif
y
> a separate query for each property.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "John Peterson" <j0hnp@.comcast.net> wrote in message
> news:O4WyV0zSEHA.3332@.tk2msftngp13.phx.gbl...
> want to invoke
> I want to set
> the best
> even though I
> "Source" record
> execute that
> User").
>|||In article <OEs7OZ4SEHA.3852@.TK2MSFTNGP10.phx.gbl>, "John Peterson" <j0hnp@.comcast.net> wrot
e:
>Thanks, Dan -- but I can't seem to get my head around your suggestion.
> Basically, what I
>want is to be able to specify a Source Query that would return a bunch of r
ows.
> Then, for
>each row, I want to invoke some ActiveX snippet withOUT doing anything to a
> "Destination".
>I don't see that it's too easy with DTS...
>
Just do it in a VBScript task.
Open a recordset.
Loop thru it and do whatever you want during each loop.|||> Thanks, Dan -- but I can't seem to get my head around your suggestion.
Basically, what I
> want is to be able to specify a Source Query that would return a bunch of
rows. Then, for
> each row, I want to invoke some ActiveX snippet withOUT doing anything to
a "Destination".
> I don't see that it's too easy with DTS...
Sorry, but I don't understand what you mean by <withOUT doing anything to a
"Destination">. Please elaborate.
If you want to assign many properties from a single query, below is an
example of the ActiveX script technique suggested by b_43@.hotmail.com.
CREATE TABLE DTSPackageProperties
(
PackageName varchar(255) NOT NULL,
ObjectName varchar(255) NOT NULL,
PropertyName varchar(255) NOT NULL,
PropertyValue varchar(255) NOT NULL,
)
ALTER TABLE DTSPackageProperties
ADD CONSTRAINT PK_DTSPackageProperties
PRIMARY KEY(PackageName, ObjectName, PropertyName)
INSERT INTO DTSPackageProperties
VALUES('MyPackage', 'MySource', 'DataSource',
'C:\InputFiles\MyInputFile.txt')
INSERT INTO DTSPackageProperties
VALUES('MyPackage', 'MyDestination', 'DataSource',
'C:\OutputFiles\MyOutputFile.txt')
Function Main()
Dim conn, rs, sqlQuery
Set conn = CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB;" & _
"Data Source=MyServer;" & _
"Integrated Security=SSPI;" & _
"Initial Catalog=MyDatabase"
sqlQuery = "SELECT ObjectName, PropertyValue"
sqlQuery = sqlQuery + " FROM DTSPackageProperties"
sqlQuery = sqlQuery + " WHERE PackageName = '"
sqlQuery = sqlQuery + DTSGlobalVariables.Parent.Name
sqlQuery = sqlQuery + "' AND PropertyName = 'DataSource'"
Set rs = conn.Execute(sqlQuery)
Do While rs.EOF = False
DTSGlobalVariables.Parent.Connections(rs.Fields("ObjectName").Value).DataSou
rce = _
rs.Fields("PropertyValue").Value
rs.MoveNext
Loop
rs.Close
conn.Close
Set rs = Nothing
Set comm = Nothing
Main = DTSTaskExecResult_Success
End Function
The alternative DynamicProperties task method would use the following
queries to assign the properties.
SELECT PropertyValue
FROM DTSPackageProperties
WHERE
PackageName = 'MyPackage' AND
ObjectName = 'MySource' AND
PropertyName = 'DataSource'
SELECT PropertyValue
FROM DTSPackageProperties
WHERE
PackageName = 'MyPackage' AND
ObjectName = 'MyDestination' AND
PropertyName = 'DataSource'
Hope this helps.
Dan Guzman
SQL Server MVP
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:OEs7OZ4SEHA.3852@.TK2MSFTNGP10.phx.gbl...
> Thanks, Dan -- but I can't seem to get my head around your suggestion.
Basically, what I
> want is to be able to specify a Source Query that would return a bunch of
rows. Then, for
> each row, I want to invoke some ActiveX snippet withOUT doing anything to
a "Destination".
> I don't see that it's too easy with DTS...
>
> "Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
> news:u8ri%23s0SEHA.3608@.TK2MSFTNGP11.phx.gbl...
DTS[vbcol=seagreen]
specify[vbcol=seagreen]
that I[vbcol=seagreen]
row,[vbcol=seagreen]
would be[vbcol=seagreen]
Task",[vbcol=seagreen]
each[vbcol=seagreen]
>|||Thanks Dan (and bb_43)!
I had hoped there would have been a simpler solution in the context of exist
ing DTS
objects, rather than having to write a lot of code. Alas, it seems like it'
s not quite
the case, even though DTS seems uniquely qualified to do this type of thing
(almost).
Since it can use a Connection to issue a query on that remote server and pro
cess the rows.
The only problem is that both the "Transform Data Task" and "Data Driven Que
ry Task" seem
to *require* a "destination" object; that you can't simply have an ActiveX t
ransformation
script for each row without having the data ultimately going somewhere.
Thanks again!
John Peterson
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:Oj%23iSG9SEHA.3476@.tk2msftngp13.phx.gbl...
> Basically, what I
> rows. Then, for
> a "Destination".
> Sorry, but I don't understand what you mean by <withOUT doing anything to
a
> "Destination">. Please elaborate.
> If you want to assign many properties from a single query, below is an
> example of the ActiveX script technique suggested by b_43@.hotmail.com.
>
> CREATE TABLE DTSPackageProperties
> (
> PackageName varchar(255) NOT NULL,
> ObjectName varchar(255) NOT NULL,
> PropertyName varchar(255) NOT NULL,
> PropertyValue varchar(255) NOT NULL,
> )
> ALTER TABLE DTSPackageProperties
> ADD CONSTRAINT PK_DTSPackageProperties
> PRIMARY KEY(PackageName, ObjectName, PropertyName)
> INSERT INTO DTSPackageProperties
> VALUES('MyPackage', 'MySource', 'DataSource',
> 'C:\InputFiles\MyInputFile.txt')
> INSERT INTO DTSPackageProperties
> VALUES('MyPackage', 'MyDestination', 'DataSource',
> 'C:\OutputFiles\MyOutputFile.txt')
> Function Main()
> Dim conn, rs, sqlQuery
> Set conn = CreateObject("ADODB.Connection")
> conn.Open "Provider=SQLOLEDB;" & _
> "Data Source=MyServer;" & _
> "Integrated Security=SSPI;" & _
> "Initial Catalog=MyDatabase"
> sqlQuery = "SELECT ObjectName, PropertyValue"
> sqlQuery = sqlQuery + " FROM DTSPackageProperties"
> sqlQuery = sqlQuery + " WHERE PackageName = '"
> sqlQuery = sqlQuery + DTSGlobalVariables.Parent.Name
> sqlQuery = sqlQuery + "' AND PropertyName = 'DataSource'"
> Set rs = conn.Execute(sqlQuery)
> Do While rs.EOF = False
> DTSGlobalVariables.Parent.Connections(rs.Fields("ObjectName").Value).DataS
ou
> rce = _
> rs.Fields("PropertyValue").Value
> rs.MoveNext
> Loop
> rs.Close
> conn.Close
> Set rs = Nothing
> Set comm = Nothing
> Main = DTSTaskExecResult_Success
> End Function
> The alternative DynamicProperties task method would use the following
> queries to assign the properties.
> SELECT PropertyValue
> FROM DTSPackageProperties
> WHERE
> PackageName = 'MyPackage' AND
> ObjectName = 'MySource' AND
> PropertyName = 'DataSource'
> SELECT PropertyValue
> FROM DTSPackageProperties
> WHERE
> PackageName = 'MyPackage' AND
> ObjectName = 'MyDestination' AND
> PropertyName = 'DataSource'
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "John Peterson" <j0hnp@.comcast.net> wrote in message
> news:OEs7OZ4SEHA.3852@.TK2MSFTNGP10.phx.gbl...
> Basically, what I
> rows. Then, for
> a "Destination".
> DTS
> specify
> that I
> row,
> would be
> Task",
> each
>|||John,
if you do want to use the Transform Data Task without inserting rows you can
change the DTSTransformStatus constant from DTSTransformStat_OK to
DTSTransformStat_SkipInsert.
HTH,
Paul Ibison|||<blush> I did not know such a return value existed! Thanks so much, Paul -
- I'm sure
that'll do the trick! (And I think you pegged my issue *exactly*!)
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23MUhxx$SEHA.2128@.TK2MSFTNGP11.phx.gbl...
> John,
> if you do want to use the Transform Data Task without inserting rows you c
an
> change the DTSTransformStatus constant from DTSTransformStat_OK to
> DTSTransformStat_SkipInsert.
> HTH,
> Paul Ibison
>|||No problem. FYI I came across this info from this book which is the most
comprehensive DTS book I know of:
_2_1/202-5145180-8774263" target="_blank">http://www.amazon.co.uk/exec/obidos...5145180-8774263
Regards,
Paul Ibisonsql
How can I print table structures in SQLExpress
I need to get a print out of column names, types, and properties for each of the tables. We just started using SQL Express from Access. I cannot find any reference to printing the structures in Microsoft SQL Server Management Studio Express.
Thanks
hi,
this is actually non avaliable at all..
you can have a "similar" result via SQL Server Management Studio Express (http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en) "Diagrams" features.. add all required tables + views and print it out.. not very beautifull but available.. or get them to clipboard and pasting them into Paint or the like...
regards
|||Sigh............................
Thanks
|||Rich
Perhaps this will help. Query your database with this:
SELECT * FROM
INFORMATION_SCHEMA.COLUMN
Copy the results into excel or something and get rid of the column you don't need.
|||Subtle wrote:
Rich
Perhaps this will help. Query your database with this:
SELECT * FROM
INFORMATION_SCHEMA.COLUMNCopy the results into excel or something and get rid of the column you don't need.
How about using sp_describe_cursor_columns? Then you can print the output from C# or something?
|||hi,
I'd better go for INFORMATION_SCHEMA ANSI view or, if your really want to go a quiet unsupported way, you could even resort on an unsupported/undocumented stored procedure, sp_MSForEach (http://www.databasejournal.com/features/mssql/article.php/3441031)..
then you can define your query to be executed against all database tables...
for instance something based on catalog views, similar to
SET NOCOUNT ON;USE AdventureWorks;
GO
DECLARE @.cmd varchar(MAX);
SET @.cmd = 'SELECT ''?'' AS [ObjName];
SELECT clmns.name AS [Name]
, usrt.name AS [DataType], ISNULL(baset.name, N'''') AS [SystemType]
, clmns.is_nullable, clmns.is_identity, clmns.is_rowguidcol, clmns.is_computed
, CASE WHEN clmns.name IN (''timestamp'', ''rowversion'') THEN 1 ELSE 0 END AS is_timestamp
, CASE WHEN clmns.default_object_id <> 0 THEN 1 ELSE 0 END AS [has_default_value]
, CASE WHEN clmns.default_object_id = 0 THEN '''' ELSE
(SELECT d.definition
FROM sys.default_constraints d
WHERE(clmns.object_id = d.parent_object_id)
AND d.parent_column_id = clmns.column_id)
END AS [Default Definition]
, CAST(CASE WHEN baset.name IN (N''nchar'', N''nvarchar'') AND clmns.max_length <> -1 THEN clmns.max_length/2 ELSE clmns.max_length END AS int) AS [Length]
, CAST(clmns.precision AS int) AS [NumericPrecision]
, CAST(clmns.scale AS int) AS [NumericScale]
FROM sys.tables AS tbl
INNER JOIN sys.all_columns AS clmns ON clmns.object_id=tbl.object_id
LEFT OUTER JOIN sys.types AS usrt ON usrt.user_type_id = clmns.user_type_id
LEFT OUTER JOIN sys.types AS baset ON baset.user_type_id = clmns.system_type_id and baset.user_type_id = baset.system_type_id
WHERE clmns.object_id = OBJECT_ID(''?'')
ORDER BY clmns.column_id ASC;'
EXEC sp_MSforeachtable @.cmd;
--<--
ObjName
-
[Production].[ProductProductPhoto]
Name DataType SystemType is_nullable is_identity is_rowguidcol is_computed is_timestamp has_default_value Default Definition Length NumericPrecision NumericScale
- -- -- -- - -- -- -- -- -
ProductID int int 0 0 0 0 0 0 4 10 0
ProductPhotoID int int 0 0 0 0 0 0 4 10 0
Primary Flag bit 0 0 0 0 0 1 ((0)) 1 1 0
ModifiedDate datetime datetime 0 0 0 0 0 1 (getdate()) 8 23 3
...other objs..
you are then obviously free to add/remove projections as required..
regards
Friday, March 23, 2012
How can I open an SQL database and be the only one who has access to it?
I'm opening an ADODB connection to an SQL database in VB6 using the
adModeShareExclusive mode for the connection object. The connection opens
successfully, but I'm still able to modify records in the database using
Enterprise Manager. Why is this? I want to open the SQL database and lock
out all other connections, i.e. anyone who tries to connect to it after I
have a successful adModeShareExclusive mode connection established should
get an error when they try to connect. At least that's what I'm trying to
accomplish so that I can do a complete rebuild of the database. I don't
want to kick everyone out of their connections when I try to connect. I'll
just keep trying until I finally get a connection when no one else is
connected. Does anyone out there know how I can do this? Maybe I should
simply be using a different mode, but which one?
Thanks,
William Hildebrand
hi William,
"William Hildebrand" <wahilde@.cableone.net> ha scritto nel messaggio
news:10lr3gghg65f074@.corp.supernews.com
> Hello,
> I'm opening an ADODB connection to an SQL database in VB6 using the
> adModeShareExclusive mode for the connection object. The connection
> opens successfully, but I'm still able to modify records in the
> database using Enterprise Manager. Why is this? I want to open the
> SQL database and lock out all other connections, i.e. anyone who
> tries to connect to it after I have a successful adModeShareExclusive
> mode connection established should get an error when they try to
> connect. At least that's what I'm trying to accomplish so that I can
> do a complete rebuild of the database. I don't want to kick everyone
> out of their connections when I try to connect. I'll just keep
> trying until I finally get a connection when no one else is
> connected. Does anyone out there know how I can do this? Maybe I
> should simply be using a different mode, but which one?
> Thanks,
> William Hildebrand
you can perhaps try another way...
setting the database in single user mode
ALTER DATABASE db_name
SET SINGLE_USER
after you established your ADO connection... eventually trap errors that
could be raised and, before closing your connection, execute
ALTER DATABASE db_name
SET MULTI_USER
please see
http://msdn.microsoft.com/library/de...aa-az_4e5h.asp
for ALTER DATABASE statement's synopsis, and the "termination" options that
could grant you further granularity...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Wednesday, March 21, 2012
how can i mapped the sql data to the ms access db?
dbase. But the MS SQL server is really connecting to an MS Access db to get
the data.How can I mapped the data of the ms access db so that when my ms
sql server connects it can get the data and display the data in my ASP.net
page.
thanksHi
Is there a linked server created to communicate with Access database?
Please refer to the BOL (Linked servers) .
"cEciLlE" <cecille.regidor@.gmail.com> wrote in message
news:%23c8TSgiEFHA.3824@.TK2MSFTNGP10.phx.gbl...
> I need to create an ASP.Net page that connects to an MS SQL server as its
> dbase. But the MS SQL server is really connecting to an MS Access db to
get
> the data.How can I mapped the data of the ms access db so that when my ms
> sql server connects it can get the data and display the data in my ASP.net
> page.
> thanks
>
Monday, March 19, 2012
how can i make checkbox
hello all i have a 2 questions hope that u can help me my first question is: in ms access there was a data type named yes/no and it was a checkbox is there a checkbox data type in sql server 2005?
my second question is i need the connection code between asp.net 2005 and sql server 2005 i searched in here for that code but i got more confuse i found two codes and both are not working so hope u can give me the right connecting code. that's all thanks
Thebitdata Type is the equivelent to ths Yes/No data type.
If you mean the connection string, it is like this for SQL Server 2005:
server=<ServerAddress>;uid=<userId>;password=<password>;database=<databaseName>
Of course, fill in the bold to the actual values. Also, heres a good website if you ever need any connection strings:
http://www.connectionstrings.com/
|||
hellojavanthanks for ur reply i tried the bit data type but no checkbox appeared and i tried to write yes but it didnt accept that value so plase hope u tell me what i shoud do? and as for the connection string i dont mean that string but i mean the main connection string for example in vs2003 when i want to connect to a database that's what i should do:
Dim conn as newsqlconnection (the string u wrote is here)
the bold statment that what i want to know? thanks for ur reply again
|||no one can help?!!!!!|||Datatypes are not restricted to a specific UI control that can display it like in Access. Some applications that use a grid-like or form-like interface to allow you to enter values into a table will display a checkbox for a column that is defined as bit (or bit not nullable), while some others will display it as it's raw value of 0 or 1. Depends on the tool.
In ASP.NET, you have the option of displaying it to the end user any way you want. I believe the form wizards by default will make a checkbox out of it, and some datagrids will as well, I am unsure of what the built in datagrid will do, I'd guess mostly a textbox with 0 or 1 in it. The gridview might be more intelligent than that, but I wouldn't bet on it either.
The bit datatype is the closest match, but you could also make a column of char(1) and store "Y"/"N" in it and use a checkbox to display it to the end user, but I know of no tools that will automatically turn that into a checkbox for you. You could also make it a varchar(3) and store "yes"/"no" in it as well, and optionally put a check constraint to make sure only the values "yes"/"no" or "Y"/"N" are able to be stored in there.
|||helloMotleythanks for ur reply and as u said there as an option in the gridview allow me to delete and select and edit in the properties box but i have another problem when i get to delete a record i have an error said that deleting is not supported by data source i serched for that error and i knew that the solution is when i configuring my data source in the data source wizard i have to click on advanced sql generation option that let me check two choices to enable insert and deleting and update the problem is that two choices are not active i dont know why so please if u can help me then i'm waiting thanks for u all.|||Sorry, I was away in Florida and couldn't check my emails. The bit data type is actually a 0 or 1 value. It is the closest thing you can get to Yes/No in Sql Server. You have to check the value of your checkbox and insert the proper data type based on that. I wouldnt recommend doing a char(1) because that is not a true yes/no type field.|||hello again javan thanks for ur care about reply but i have a little problem as i said in my last post that advanced option button is not active so i hope u can really help cos i really need that option thanks for u all.|||Yes,... I found this problem in the SQL DataSource too before. It seems that once the datasource is created then the option is not available when you go to edit it. What you have to do is delete and then recreate the datasource and make sure you press the advanced options on the first try. The check the "Generate Insert/Edit/Delete" checkbox.|||hello JAVAN thanks for ur reply i did as u said but no use problem still exist anyway i sent u private msg hope u reply it thanks again.|||The "Generate Insert,Update,etc..." checkbox may not be visible if you are not returning a Primary Key field from the database or if you do not have one defined. You must return a PRimary Key field from the select statement for the SQL DataSource to be able to update the records.
|||hello dear javan
i have that problem(update&.. checkboxes) for about 6 days but ur answers help me tp solve it.
so thanks for ever
be lucky and successful like always
Wednesday, March 7, 2012
How can I import a MDB database into SQL 2005 ?
from Access MDB to SQL 2005 ?
Thanks
Javier
I am using the free version of SPAMfighter for private users.
It has removed 9800 spam emails to date.
Paying users do not have this message in their emails.
Try www.SPAMfighter.com for free now!
Regarding SQL Server 2005, you should probably post to the beta newsgroups.
You will probably receive more help there since that is the place that
questions related to SQL Server 2005 should be asked.
http://communities.microsoft.com/new...r2005&slcid=us
If you want to access the newsgroups via your newsreader just scroll through
the top right hand frame for connection information
Keith
"JAV" <mask@.impsat1.com.ar> wrote in message
news:uGFVOW%23gFHA.3436@.tk2msftngp13.phx.gbl...
> Hi, could you tell me how can I do the "migration Wizard" for import data
> from Access MDB to SQL 2005 ?
> Thanks
> Javier
>
> --
> I am using the free version of SPAMfighter for private users.
> It has removed 9800 spam emails to date.
> Paying users do not have this message in their emails.
> Try www.SPAMfighter.com for free now!
>
How can I import a MDB database into SQL 2005 ?
from Access MDB to SQL 2005 ?
Thanks
Javier
I am using the free version of SPAMfighter for private users.
It has removed 9800 spam emails to date.
Paying users do not have this message in their emails.
Try www.SPAMfighter.com for free now!Regarding SQL Server 2005, you should probably post to the beta newsgroups.
You will probably receive more help there since that is the place that
questions related to SQL Server 2005 should be asked.
http://communities.microsoft.com/ne...lcid=us
If you want to access the newsgroups via your newsreader just scroll through
the top right hand frame for connection information
Keith
"JAV" <mask@.impsat1.com.ar> wrote in message
news:uGFVOW%23gFHA.3436@.tk2msftngp13.phx.gbl...
> Hi, could you tell me how can I do the "migration Wizard" for import data
> from Access MDB to SQL 2005 ?
> Thanks
> Javier
>
> --
> I am using the free version of SPAMfighter for private users.
> It has removed 9800 spam emails to date.
> Paying users do not have this message in their emails.
> Try www.SPAMfighter.com for free now!
>
How can I import a MDB database into SQL 2005 ?
from Access MDB to SQL 2005 ?
Thanks
Javier
--
I am using the free version of SPAMfighter for private users.
It has removed 9800 spam emails to date.
Paying users do not have this message in their emails.
Try www.SPAMfighter.com for free now!Regarding SQL Server 2005, you should probably post to the beta newsgroups.
You will probably receive more help there since that is the place that
questions related to SQL Server 2005 should be asked.
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us
If you want to access the newsgroups via your newsreader just scroll through
the top right hand frame for connection information
--
Keith
"JAV" <mask@.impsat1.com.ar> wrote in message
news:uGFVOW%23gFHA.3436@.tk2msftngp13.phx.gbl...
> Hi, could you tell me how can I do the "migration Wizard" for import data
> from Access MDB to SQL 2005 ?
> Thanks
> Javier
>
> --
> I am using the free version of SPAMfighter for private users.
> It has removed 9800 spam emails to date.
> Paying users do not have this message in their emails.
> Try www.SPAMfighter.com for free now!
>
Monday, February 27, 2012
How can I get the username from an application?
Here the environment is application in 3 layers.
So the user in his client machine, access the application in an application server that sends the request to my sql server database server.
My problem is: when I run sp_who from Query Analyzer, I see the host name that is pre-defined inside code application. But, actually, I need to know the user who is requesting the transactio so I can know right the person who is slowing my database performance...
Do you know, any function, procedure or anything else that I can use in the application code in order to provide the user or the host name from the client machine???
I hope some answers...
Thank you all,Look up NILADIC functions in Books Online.|||host_name()|||Hi all,
I have this doubt: may I apply SP3a in my SQL Server production database while it is operational?
I mean, may I do this version upgrade while the databases are online and users continue accessing the databases normally?
My actual version is 8.00.194 (no SP applied), and I am planning to apply SP3a.
Thank you in advance,|||No, when applying sp3a to a server that is currently at RTM (what you load from the CD) will require a reboot of Windows. There will be a brief service interruption while the machine reboots.
-PatP|||host_name()Will host_name() help in a three tier environment? I would expect it to return the name of the middleware server.
-PatP|||So this function host_name() doesn't help me, because I need to see the client host name during sp_who...
Does someone can explain a solution for this?
Thanks,|||The easiest way is to have your middleware set the hostname (http://support.microsoft.com/default.aspx?scid=kb;en-us;140301) equal to however it identifies the caller (user name, account number, etc). There are other ways to do this, but they get ugly very quickly and each solution is VERY specific to the installation/application involved.
-PatP
How can I get the table schema using Entreprise Library DAAB ?
i'm using the DAAB (Enterprise Library) to access the data in my system. But I need to use the schema from the tables i'm reading....
when I was using the default DataAdapter, I have used the FillSchema() method, but now, when I use de DAAB to fill de data, I couldn't get the primary keys columns, unique columns neither autoincrement columns...
This is the code that i'm using to get the data with DAAB:
===========================
Database db = DatabaseFactory.CreateDatabase();
DBCommandWrapper cmd = db.GetSqlStringCommandWrapper("SELECT * FROM Customer");
ds = db.ExecuteDataSet(cmd);
===========================
But this code don't return the schema from the "Customer" table.
Do you have any tip to do it?
thanks people
Andr
Since this is not a Data Mining question, can you try posting to one of these forums?:
.NET Framework Data Access and Storage (http://forums.microsoft.com/msdn/ShowForum.aspx?ForumID=45)
SQL Server Data Access (http://forums.microsoft.com/msdn/ShowForum.aspx?ForumID=87)
Raman Iyer
SQL Server Data Mining
http://www.sqlserverdatamining.com
How can I get the lable of a Parameter ?
Paramaters!Name.Value .I'm using a dropdown in my report which has lable and
values ,I'd like to get the lable not the value.
How can I do that?
Thanks for your time in advance.
AliHi Ali,
I find that =Paramaters!Name.Label will work MOST of the time.
I have several queried parameters and one that is not queried but has
values and lablels like: ="Q1-" & Year(Today)
The queried parameters work perfect with =Paramaters!Name.Label, but
the non queried parameter does not print if I use .Label However, it
will print if I use .Value
Take care,
Michelle|||My Problem is that I am using a non-queried parametre:-(
and I get an error if I use Parameters!Name.Value.What a bizzare,Isn't it?
Maybe Microsoft guys should add it to their wish list;-)
Ali
<Michelle@.bwalk.com> wrote in message
news:1106693367.969333.310150@.c13g2000cwb.googlegroups.com...
> Hi Ali,
> I find that =Paramaters!Name.Label will work MOST of the time.
> I have several queried parameters and one that is not queried but has
> values and lablels like: ="Q1-" & Year(Today)
> The queried parameters work perfect with =Paramaters!Name.Label, but
> the non queried parameter does not print if I use .Label However, it
> will print if I use .Value
>
> Take care,
> Michelle
>|||I'll double check this tomorrow at work but I don't think this is true.
.Label should always work. One thing to keep in mind is that the parameter
name is case sensitive. Parameters!somename.Value is not the same as
Parameters!SomeName.Value. Be sure that you have your parameter with the
appropriate case.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ALI-R" <newbie@.microsoft.com> wrote in message
news:%23wTTcHzAFHA.3988@.TK2MSFTNGP11.phx.gbl...
> My Problem is that I am using a non-queried parametre:-(
> and I get an error if I use Parameters!Name.Value.What a bizzare,Isn't it?
> Maybe Microsoft guys should add it to their wish list;-)
> Ali
> <Michelle@.bwalk.com> wrote in message
> news:1106693367.969333.310150@.c13g2000cwb.googlegroups.com...
>> Hi Ali,
>> I find that =Paramaters!Name.Label will work MOST of the time.
>> I have several queried parameters and one that is not queried but has
>> values and lablels like: ="Q1-" & Year(Today)
>> The queried parameters work perfect with =Paramaters!Name.Label, but
>> the non queried parameter does not print if I use .Label However, it
>> will print if I use .Value
>>
>> Take care,
>> Michelle
>|||Yes,Bruse it is working,I misspelled Label as Lable:-) ,Funny then
Thanks for your help guys
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eMb8inzAFHA.724@.TK2MSFTNGP10.phx.gbl...
> I'll double check this tomorrow at work but I don't think this is true.
> .Label should always work. One thing to keep in mind is that the parameter
> name is case sensitive. Parameters!somename.Value is not the same as
> Parameters!SomeName.Value. Be sure that you have your parameter with the
> appropriate case.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ALI-R" <newbie@.microsoft.com> wrote in message
> news:%23wTTcHzAFHA.3988@.TK2MSFTNGP11.phx.gbl...
> > My Problem is that I am using a non-queried parametre:-(
> > and I get an error if I use Parameters!Name.Value.What a bizzare,Isn't
it?
> > Maybe Microsoft guys should add it to their wish list;-)
> >
> > Ali
> >
> > <Michelle@.bwalk.com> wrote in message
> > news:1106693367.969333.310150@.c13g2000cwb.googlegroups.com...
> >> Hi Ali,
> >>
> >> I find that =Paramaters!Name.Label will work MOST of the time.
> >>
> >> I have several queried parameters and one that is not queried but has
> >> values and lablels like: ="Q1-" & Year(Today)
> >>
> >> The queried parameters work perfect with =Paramaters!Name.Label, but
> >> the non queried parameter does not print if I use .Label However, it
> >> will print if I use .Value
> >>
> >>
> >> Take care,
> >> Michelle
> >>
> >
> >
>
How can I get the keyword list indexed by SQL Server 2005
Full Text search must keep a list of key words or items somewhere.
How can I get access to this list to present to a user.
For example: show me all indexed words starting with letter a* and then ac*.
I'm trying to find this information without success.
Full Text uses only predicates so what you are asking are actually noise word and you can find the noise words for supported languages in the location below in your C drive. Hope this helps.
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData
|||As far as I know there is no way built in way to get the list from fulltext service as the data is stored natively by FTS.
Jens K. Suessmeyer
http://www.sqlserver2005.de