sql local data: file

Showing posts with label file. Show all posts

Friday, March 30, 2012

Lock: Timeout - @@LOCK_TIMEOUT

Hi,
Trace file which I have here, contains many Lock: Timeout
events. I don't understand how is it possible when
@.@.LOCK_TIMEOUT is set to -1 for all connections.
Thanks,
OJThis event is generated by a low level system component. Please post the
entire event data column for us to understand the situation.
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"OJ" <anonymous@.discussions.microsoft.com> wrote in message
news:200b01c4dca6$c0f48a30$a301280a@.phx.gbl...
> Hi,
> Trace file which I have here, contains many Lock: Timeout
> events. I don't understand how is it possible when
> @.@.LOCK_TIMEOUT is set to -1 for all connections.
> Thanks,
> OJ|||I'm not sure how this can help, but here it is (one of
many examples):
row_number=188337
event_class=27
text_Data=NULL
Binary_data=0x000707000DD07C4F23006F01DE541AB4
DatabaseID=14
HostName=PROD1
SPID=73
ObjectID=1333579789
IndexID=30
Mode=3
Also, some of them are caused by SPID lower than 50, and
mode in that case is: 5.
Thanks,
OJ
>--Original Message--
>This event is generated by a low level system component.
Please post the
>entire event data column for us to understand the
situation.
>--
>Wei Xiao [MSFT]
>SQL Server Storage Engine Development
>http://weblogs.asp.net/weix
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>"OJ" <anonymous@.discussions.microsoft.com> wrote in
message
>news:200b01c4dca6$c0f48a30$a301280a@.phx.gbl...
>> Hi,
>> Trace file which I have here, contains many Lock:
Timeout
>> events. I don't understand how is it possible when
>> @.@.LOCK_TIMEOUT is set to -1 for all connections.
>> Thanks,
>> OJ
>
>.
>|||As an optimization, SQL Server internally needs to check if a transaction
can acquire some locks without waiting. When this fails, the lock timeout
event is generated (with a duration of 0) but SQL Server will wait for the
lock instead.
The value of the "Duration" column indicates for how long SQL Server waits
before the timeout. If the value is 0, then this is the internal no-wait
timeout.
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"OJ" <anonymous@.discussions.microsoft.com> wrote in message
news:193d01c4dd59$34acbc60$a501280a@.phx.gbl...
> I'm not sure how this can help, but here it is (one of
> many examples):
> row_number=188337
> event_class=27
> text_Data=NULL
> Binary_data=0x000707000DD07C4F23006F01DE541AB4
> DatabaseID=14
> HostName=PROD1
> SPID=73
> ObjectID=1333579789
> IndexID=30
> Mode=3
>
> Also, some of them are caused by SPID lower than 50, and
> mode in that case is: 5.
> Thanks,
> OJ
>>--Original Message--
>>This event is generated by a low level system component.
> Please post the
>>entire event data column for us to understand the
> situation.
>>--
>>Wei Xiao [MSFT]
>>SQL Server Storage Engine Development
>>http://weblogs.asp.net/weix
>>This posting is provided "AS IS" with no warranties, and
> confers no rights.
>>"OJ" <anonymous@.discussions.microsoft.com> wrote in
> message
>>news:200b01c4dca6$c0f48a30$a301280a@.phx.gbl...
>> Hi,
>> Trace file which I have here, contains many Lock:
> Timeout
>> events. I don't understand how is it possible when
>> @.@.LOCK_TIMEOUT is set to -1 for all connections.
>> Thanks,
>> OJ
>>
>>.|||Thanks
>--Original Message--
>As an optimization, SQL Server internally needs to check
if a transaction
>can acquire some locks without waiting. When this fails,
the lock timeout
>event is generated (with a duration of 0) but SQL Server
will wait for the
>lock instead.
>The value of the "Duration" column indicates for how long
SQL Server waits
>before the timeout. If the value is 0, then this is the
internal no-wait
>timeout.
>--
>Wei Xiao [MSFT]
>SQL Server Storage Engine Development
>http://weblogs.asp.net/weix
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>"OJ" <anonymous@.discussions.microsoft.com> wrote in
message
>news:193d01c4dd59$34acbc60$a501280a@.phx.gbl...
>> I'm not sure how this can help, but here it is (one of
>> many examples):
>> row_number=188337
>> event_class=27
>> text_Data=NULL
>> Binary_data=0x000707000DD07C4F23006F01DE541AB4
>> DatabaseID=14
>> HostName=PROD1
>> SPID=73
>> ObjectID=1333579789
>> IndexID=30
>> Mode=3
>>
>> Also, some of them are caused by SPID lower than 50, and
>> mode in that case is: 5.
>> Thanks,
>> OJ
>>--Original Message--
>>This event is generated by a low level system component.
>> Please post the
>>entire event data column for us to understand the
>> situation.
>>--
>>Wei Xiao [MSFT]
>>SQL Server Storage Engine Development
>>http://weblogs.asp.net/weix
>>This posting is provided "AS IS" with no warranties, and
>> confers no rights.
>>"OJ" <anonymous@.discussions.microsoft.com> wrote in
>> message
>>news:200b01c4dca6$c0f48a30$a301280a@.phx.gbl...
>> Hi,
>> Trace file which I have here, contains many Lock:
>> Timeout
>> events. I don't understand how is it possible when
>> @.@.LOCK_TIMEOUT is set to -1 for all connections.
>> Thanks,
>> OJ
>>
>>.
>
>.
>sql

Wednesday, March 21, 2012

Location of SQL-datafile after installation of VB 2005 DB-application

Hello Experts,

I am relatively new to VB 2005 and SQL Express. I have a question concerning where I can find the SQL-database file (*.mdf) after I have installed (published) my VB 2005 database-application (the *.mdf file was created by Visual Studio Express?). It seems it is nowhere in the disk of the of pc it is installed on. So, what happens to *.mdf file after installation of the application, in what way I can connect to the *.mdf file after the application - the file is part of - is published?

In need of help,

That depends on wheter you are using User instances (standalone mdf files with a SQL Server Express) or server attached files. User instances are normally put in the app_Data directory, whereas saved and marked for deploy and installation will be placed in the appropiate configured folder.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||Thank you for your reply,

I found finally the *.mdf files (along with the rest of the program files) installed as hidden folders under C:\Documents and Settings\User\Local Settings\...Data\. So, in this respect problem is solved. Obviously, I was using User Instances - at least in the end of my app's ConnectionString I was "User Instance=True". Does this mean that I am using user instances? - And if I mark "User Instance=False" will the installation program automatically attach the *.mdf data file then to SQL Express local server?

And if so, then I have another troublesome question. I am creating an VB DB-application whose DB-structure will change later (further tables will be added later). And my client will add data already data into database of preliminary version. Then I later will update / redeploy (with ClickOnce method) the application - so will the redeployment of the new version of application overwrite the data in SQL-database of older version? - i.e. does the new database file (with nothing or meaningless test data in it) replace the older database content (It would be serious damage to overwrite that data). The change of DB-structure is a another problem.

Could you, please, clarify for me what should I do,

Matti

|||

ClickOnce installation replaces all of the project files, including your database file. This is a short comming in how VS handles database files in 2005. You'll have to find an alternative way to deal with deployment within the ClickOnce framework.

Happily, you can watch the web cast I recorded discussing just such an alternative, links to both the 'cast and the source code demonstrated are available from this blog post.

Mike

|||

Mike,

thank you very much for your reply - and your SQL Server Express WebLog. That is all now and in coming days very important information for me that.

Well, I have started to consider not to include mdf-file in the deployment process at all but install (attach) it manually on a deployment pc via SQL Server Management Studio Express (which of course needs then to be installed on the deployment pc as well). In this way I will not certainly touch in the process of redeployment / update the inserted data in DB.

Also this makes the future changes of DB-structure easier for me; I can perform them through SSMS via SQL: simply add here new tables and relationships.

Thank you,

Location of SQL-datafile after installation of VB 2005 DB-application

Hello Experts,

In need of help,

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||Thank you for your reply,

Could you, please, clarify for me what should I do,

Matti

|||

Happily, you can watch the web cast I recorded discussing just such an alternative, links to both the 'cast and the source code demonstrated are available from this blog post.

Mike

|||

Mike,

thank you very much for your reply - and your SQL Server Express WebLog. That is all now and in coming days very important information for me that.

Also this makes the future changes of DB-structure easier for me; I can perform them through SSMS via SQL: simply add here new tables and relationships.

Thank you,

location of rdl files on server

Hi there ,
I am working on SSRS and I just wanted to know where
are the .rdl file stored on the server.I came along this problem as i
was searching a way to make the report content dynamic rather make the
report content customizable .I just wanted to know is there a way to
change rdl files to make them customizable.
thanks.AFAIK, the files are not stored anywhere. When you upload a report, the definition (contents of the
RDL file) is inserted into one or more tables in the report database. I'm not RS expert, though, so
you might want to verify this in an RS forum.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"unixbf" <bondfranco@.gmail.com> wrote in message
news:d2323315-9f7f-44a1-9d32-49795ad3efc2@.v46g2000hsv.googlegroups.com...
> Hi there ,
> I am working on SSRS and I just wanted to know where
> are the .rdl file stored on the server.I came along this problem as i
> was searching a way to make the report content dynamic rather make the
> report content customizable .I just wanted to know is there a way to
> change rdl files to make them customizable.
> thanks.|||Tibor Karaszi wrote:
> AFAIK, the files are not stored anywhere. When you upload a report, the definition (contents of the
> RDL file) is inserted into one or more tables in the report database. I'm not RS expert, though, so
> you might want to verify this in an RS forum.
>
true!

location of rdl files on report server

Hi there ,
I am working on SSRS and I just wanted to know where
are the .rdl file stored on the server.I came along this problem as i
was searching a way to make the report content dynamic rather make the
report content customizable .I just wanted to know is there a way to
change rdl files to make them customizable.
thanks.RDL files are not stored as files on the server. They are stored in the
database. Essentially you have to redeploy the rdl file which you can do by
using webservices. However, you cannot do this for a specific user.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"unixbf" <bondfranco@.gmail.com> wrote in message
news:448b5c16-8146-48b0-a412-8e38d873955d@.v67g2000hse.googlegroups.com...
> Hi there ,
> I am working on SSRS and I just wanted to know where
> are the .rdl file stored on the server.I came along this problem as i
> was searching a way to make the report content dynamic rather make the
> report content customizable .I just wanted to know is there a way to
> change rdl files to make them customizable.
> thanks.

Location of ERRORLOG and SQLAGENNT.OUT

SQL Server 2000, Windows 2003 R2, Cluster 5.2
We're setting up a new cluster and I would like to move the LOGFILE and
SQLAGENT.OUT file off of the drive(s) that contain .ldf & .mdf files. My
reason is that these files will contribute to drive fragmentation (also, I
would like it to be a simpler path to get to the files, something right off
of the drive root).
Now, I've never done this on a cluster before and our Windows admin is
telling me that these logs are somehow used by the cluster administrator to
do some part of the failover. I'm unclear how.
Anyway, The drives I have available are:
C: OS (not shared)
E: Apps (SQL Server Install/not shared)
Q: Quorum
L: Logs (shared)
S: Data (shared)
R: Backup (shared)
The ERRORLOG & SQLAGENT.OUT files are currently on S: under the "S:\Program
Files\Microsoft SQL Server\MSSQL\LOG" path (same disk as the data files) and
I would like to place them on the E: drive (which is not shared).
I can see that this would cause me to not have log entries from the other
server immediatly available to me on a changeover as it wouldn't be on a
shared disk -- and I don't know if that is a bad thing, or not.
Can I, or should I, move these log files off the disk with the data files?
Thanks,
Jay
These log files hardly cause any significant fragmentation that would have a
significant impact on the database performance.
I have never tried to move the log files to local non-shared disks, and will
probably never try it since that is not the way it is supposed to work.
Even if you managed to relocate the log files to E, consider this. When your
instance is running on node A, and the logs would be on the E drive on node
A. If then node A is hosed, your SQL instance will fail over to another node,
but your log files. So you won't have access to the log files for
troubleshooting. Not good! Okay, the cluster service may manage to replicate
some of the errorlog entries that are also writtne to the app eventlog to the
other nodes, but the completeness of that is not guaranteed when there is a
sudden failure.
Don't do it!
Linchi
"Jay" wrote:

> SQL Server 2000, Windows 2003 R2, Cluster 5.2
> We're setting up a new cluster and I would like to move the LOGFILE and
> SQLAGENT.OUT file off of the drive(s) that contain .ldf & .mdf files. My
> reason is that these files will contribute to drive fragmentation (also, I
> would like it to be a simpler path to get to the files, something right off
> of the drive root).
> Now, I've never done this on a cluster before and our Windows admin is
> telling me that these logs are somehow used by the cluster administrator to
> do some part of the failover. I'm unclear how.
> Anyway, The drives I have available are:
> C: OS (not shared)
> E: Apps (SQL Server Install/not shared)
> Q: Quorum
> L: Logs (shared)
> S: Data (shared)
> R: Backup (shared)
> The ERRORLOG & SQLAGENT.OUT files are currently on S: under the "S:\Program
> Files\Microsoft SQL Server\MSSQL\LOG" path (same disk as the data files) and
> I would like to place them on the E: drive (which is not shared).
> I can see that this would cause me to not have log entries from the other
> server immediatly available to me on a changeover as it wouldn't be on a
> shared disk -- and I don't know if that is a bad thing, or not.
> Can I, or should I, move these log files off the disk with the data files?
> Thanks,
> Jay
>
>
|||Point taken, thanks.
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:2B7D6FFA-DAF5-4F1A-8479-95AD50156DE7@.microsoft.com...[vbcol=seagreen]
> These log files hardly cause any significant fragmentation that would have
> a
> significant impact on the database performance.
> I have never tried to move the log files to local non-shared disks, and
> will
> probably never try it since that is not the way it is supposed to work.
> Even if you managed to relocate the log files to E, consider this. When
> your
> instance is running on node A, and the logs would be on the E drive on
> node
> A. If then node A is hosed, your SQL instance will fail over to another
> node,
> but your log files. So you won't have access to the log files for
> troubleshooting. Not good! Okay, the cluster service may manage to
> replicate
> some of the errorlog entries that are also writtne to the app eventlog to
> the
> other nodes, but the completeness of that is not guaranteed when there is
> a
> sudden failure.
> Don't do it!
> Linchi
> "Jay" wrote:
sql

Location of deployed rdl file on the ReportingServer

Hi all,
I have a reporting server on which My rdl files are deployed from my
development machine.
Can any one tell me where is the physical location of those rdl files on
the reporting server where the files get deployed.
I did a search for rdl files on the Reportingserver but I could not found any.
Also is it possible to add a .rdl file from the ReportServer machine to my
VS.NET project IDE on a remote development machine
Any suggestions will be highly appreciated.
Thanks in advance,
siajThe RDL files are stored in the report server database. They are not stored
on disk.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"siaj" <siaj@.discussions.microsoft.com> wrote in message
news:DABA9613-D421-4F10-AE66-5BB0D46BFBCD@.microsoft.com...
> Hi all,
> I have a reporting server on which My rdl files are deployed from my
> development machine.
> Can any one tell me where is the physical location of those rdl files on
> the reporting server where the files get deployed.
> I did a search for rdl files on the Reportingserver but I could not found
> any.
> Also is it possible to add a .rdl file from the ReportServer machine to my
> VS.NET project IDE on a remote development machine
> Any suggestions will be highly appreciated.
> Thanks in advance,
> siaj|||On Mon, 24 Jan 2005 15:13:02 -0800, "siaj"
<siaj@.discussions.microsoft.com> wrote:
>Hi all,
>I have a reporting server on which My rdl files are deployed from my
>development machine.
>Can any one tell me where is the physical location of those rdl files on
>the reporting server where the files get deployed.
>I did a search for rdl files on the Reportingserver but I could not found any.
>Also is it possible to add a .rdl file from the ReportServer machine to my
>VS.NET project IDE on a remote development machine
>Any suggestions will be highly appreciated.
>Thanks in advance,
>siaj
The deployed reports are stored in the RS database (default name -
ReportServer), not in physical files. The table name is "Catalog".
If you need to change a deployed report, you can download it from the
Report Server web page and use it in your VS project. Open the list of
reports (http://<servername>/Reports/Pages/Folder.aspx), click "Show
Details" on the toolbar. Now click the Edit icon preceeding the report
you need, this will open the properties page for the report. There are
2 links under "Report Definition": Edit and Update. "Edit" downloads
the RDL file for you, and "Update" allows you to upload the file back.|||Thanks Lukasz/Usenet
siaj
"Usenet User" wrote:
> On Mon, 24 Jan 2005 15:13:02 -0800, "siaj"
> <siaj@.discussions.microsoft.com> wrote:
> >Hi all,
> >I have a reporting server on which My rdl files are deployed from my
> >development machine.
> >Can any one tell me where is the physical location of those rdl files on
> >the reporting server where the files get deployed.
> >I did a search for rdl files on the Reportingserver but I could not found any.
> >
> >Also is it possible to add a .rdl file from the ReportServer machine to my
> >VS.NET project IDE on a remote development machine
> >
> >Any suggestions will be highly appreciated.
> >
> >Thanks in advance,
> >siaj
>
> The deployed reports are stored in the RS database (default name -
> ReportServer), not in physical files. The table name is "Catalog".
> If you need to change a deployed report, you can download it from the
> Report Server web page and use it in your VS project. Open the list of
> reports (http://<servername>/Reports/Pages/Folder.aspx), click "Show
> Details" on the toolbar. Now click the Edit icon preceeding the report
> you need, this will open the properties page for the report. There are
> 2 links under "Report Definition": Edit and Update. "Edit" downloads
> the RDL file for you, and "Update" allows you to upload the file back.
>

Location for Temporary File

I have created the following table in Northwind Database:
CREATE TABLE #dts(c1 char(1), dt datetime)
INSERT INTO #dts (c1, dt) VALUES('a', '20040305 09:12:59')
INSERT INTO #dts (c1, dt) VALUES('b', '20040305 16:03:12')
INSERT INTO #dts (c1, dt) VALUES('c', '20040306 00:00:00')
INSERT INTO #dts (c1, dt) VALUES('d', '20040306 02:41:32')
INSERT INTO #dts (c1, dt) VALUES('e', '20040315 11:45:17')
INSERT INTO #dts (c1, dt) VALUES('f', '20040412 09:12:59')
INSERT INTO #dts (c1, dt) VALUES('g', '20040523 11:43:25')
However, when I search in both Northwind and Tempdb
databases, I am not able to find it. I would like to know
where is the Temporary Table being created ?
Thanks
Hi,
All the # (temp) tables and ## (global temp) table will be created in TEMPDB
database. But for temp tables the name will be
created with a unique prefix. This is because temp tables are created every
session and each session a unqie table needs to be created.
How to see this..
Select name from tempdb..sysobjects where name like 'dts%'
Thanks
Hari
SQL Server MVP
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:0a0f01c56d8c$8f52e270$a401280a@.phx.gbl...
>I have created the following table in Northwind Database:
> CREATE TABLE #dts(c1 char(1), dt datetime)
> INSERT INTO #dts (c1, dt) VALUES('a', '20040305 09:12:59')
> INSERT INTO #dts (c1, dt) VALUES('b', '20040305 16:03:12')
> INSERT INTO #dts (c1, dt) VALUES('c', '20040306 00:00:00')
> INSERT INTO #dts (c1, dt) VALUES('d', '20040306 02:41:32')
> INSERT INTO #dts (c1, dt) VALUES('e', '20040315 11:45:17')
> INSERT INTO #dts (c1, dt) VALUES('f', '20040412 09:12:59')
> INSERT INTO #dts (c1, dt) VALUES('g', '20040523 11:43:25')
> However, when I search in both Northwind and Tempdb
> databases, I am not able to find it. I would like to know
> where is the Temporary Table being created ?
> Thanks
|||In TempDB
Run the query after your creation
IF OBJECT_ID('tempdb..#dts') IS NOT NULL
PRINT 'TempDB'
ELSE
PRINT 'No'
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:0a0f01c56d8c$8f52e270$a401280a@.phx.gbl...
> I have created the following table in Northwind Database:
> CREATE TABLE #dts(c1 char(1), dt datetime)
> INSERT INTO #dts (c1, dt) VALUES('a', '20040305 09:12:59')
> INSERT INTO #dts (c1, dt) VALUES('b', '20040305 16:03:12')
> INSERT INTO #dts (c1, dt) VALUES('c', '20040306 00:00:00')
> INSERT INTO #dts (c1, dt) VALUES('d', '20040306 02:41:32')
> INSERT INTO #dts (c1, dt) VALUES('e', '20040315 11:45:17')
> INSERT INTO #dts (c1, dt) VALUES('f', '20040412 09:12:59')
> INSERT INTO #dts (c1, dt) VALUES('g', '20040523 11:43:25')
> However, when I search in both Northwind and Tempdb
> databases, I am not able to find it. I would like to know
> where is the Temporary Table being created ?
> Thanks
|||Dear Hari,
I do find it by using your query.
In this way, if I want to make query of that temporary table, should I use
the table name dts?
Besides, you mention that temp tables are created every session, does it
mean that it will be deleted automatically at a specific time ? If yes, when
(Like - When I stop SQL Service) ?
Thanks
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eA7wxCZbFHA.3712@.TK2MSFTNGP09.phx.gbl...
> Hi,
> All the # (temp) tables and ## (global temp) table will be created in
> TEMPDB database. But for temp tables the name will be
> created with a unique prefix. This is because temp tables are created
> every session and each session a unqie table needs to be created.
> How to see this..
> Select name from tempdb..sysobjects where name like 'dts%'
> Thanks
> Hari
> SQL Server MVP
>
> "Peter" <anonymous@.discussions.microsoft.com> wrote in message
> news:0a0f01c56d8c$8f52e270$a401280a@.phx.gbl...
>
|||Why bother about the physical name? Just use the temp table name you gave it.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:0a0f01c56d8c$8f52e270$a401280a@.phx.gbl...
>I have created the following table in Northwind Database:
> CREATE TABLE #dts(c1 char(1), dt datetime)
> INSERT INTO #dts (c1, dt) VALUES('a', '20040305 09:12:59')
> INSERT INTO #dts (c1, dt) VALUES('b', '20040305 16:03:12')
> INSERT INTO #dts (c1, dt) VALUES('c', '20040306 00:00:00')
> INSERT INTO #dts (c1, dt) VALUES('d', '20040306 02:41:32')
> INSERT INTO #dts (c1, dt) VALUES('e', '20040315 11:45:17')
> INSERT INTO #dts (c1, dt) VALUES('f', '20040412 09:12:59')
> INSERT INTO #dts (c1, dt) VALUES('g', '20040523 11:43:25')
> However, when I search in both Northwind and Tempdb
> databases, I am not able to find it. I would like to know
> where is the Temporary Table being created ?
> Thanks
|||Peter wrote:
> Dear Hari,
> I do find it by using your query.
> In this way, if I want to make query of that temporary table, should I use
> the table name dts?
Why not use the temp name (#dts)?

> Besides, you mention that temp tables are created every session, does it
> mean that it will be deleted automatically at a specific time ? If yes, when
> (Like - When I stop SQL Service) ?
>
The table will be dropped as soon as the connection is closed.
Are you trying to access this table from a different connection?
If so, you might want a global temp as already specified ##TableName.
This should be available until the service is restarted.
The beauty of temp tables is they are localized to your current
connection so you can use them in a sp for instance and guarantee that
nothing else will disturb your temp table.
You might well be able to query the name from tempdb and then use it
'normally' but this would defeat the purpose of temp tables and could
well introduce some nasty side effects.
Cheers
JB

> Thanks
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:eA7wxCZbFHA.3712@.TK2MSFTNGP09.phx.gbl...
>
>

Monday, March 19, 2012

Location for Temporary File

I have created the following table in Northwind Database:
CREATE TABLE #dts(c1 char(1), dt datetime)
INSERT INTO #dts (c1, dt) VALUES('a', '20040305 09:12:59')
INSERT INTO #dts (c1, dt) VALUES('b', '20040305 16:03:12')
INSERT INTO #dts (c1, dt) VALUES('c', '20040306 00:00:00')
INSERT INTO #dts (c1, dt) VALUES('d', '20040306 02:41:32')
INSERT INTO #dts (c1, dt) VALUES('e', '20040315 11:45:17')
INSERT INTO #dts (c1, dt) VALUES('f', '20040412 09:12:59')
INSERT INTO #dts (c1, dt) VALUES('g', '20040523 11:43:25')
However, when I search in both Northwind and Tempdb
databases, I am not able to find it. I would like to know
where is the Temporary Table being created ?
ThanksHi,
All the # (temp) tables and ## (global temp) table will be created in TEMPDB
database. But for temp tables the name will be
created with a unique prefix. This is because temp tables are created every
session and each session a unqie table needs to be created.
How to see this..
Select name from tempdb..sysobjects where name like 'dts%'
Thanks
Hari
SQL Server MVP
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:0a0f01c56d8c$8f52e270$a401280a@.phx.gbl...
>I have created the following table in Northwind Database:
> CREATE TABLE #dts(c1 char(1), dt datetime)
> INSERT INTO #dts (c1, dt) VALUES('a', '20040305 09:12:59')
> INSERT INTO #dts (c1, dt) VALUES('b', '20040305 16:03:12')
> INSERT INTO #dts (c1, dt) VALUES('c', '20040306 00:00:00')
> INSERT INTO #dts (c1, dt) VALUES('d', '20040306 02:41:32')
> INSERT INTO #dts (c1, dt) VALUES('e', '20040315 11:45:17')
> INSERT INTO #dts (c1, dt) VALUES('f', '20040412 09:12:59')
> INSERT INTO #dts (c1, dt) VALUES('g', '20040523 11:43:25')
> However, when I search in both Northwind and Tempdb
> databases, I am not able to find it. I would like to know
> where is the Temporary Table being created ?
> Thanks|||In TempDB
Run the query after your creation
IF OBJECT_ID('tempdb..#dts') IS NOT NULL
PRINT 'TempDB'
ELSE
PRINT 'No'
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:0a0f01c56d8c$8f52e270$a401280a@.phx.gbl...
> I have created the following table in Northwind Database:
> CREATE TABLE #dts(c1 char(1), dt datetime)
> INSERT INTO #dts (c1, dt) VALUES('a', '20040305 09:12:59')
> INSERT INTO #dts (c1, dt) VALUES('b', '20040305 16:03:12')
> INSERT INTO #dts (c1, dt) VALUES('c', '20040306 00:00:00')
> INSERT INTO #dts (c1, dt) VALUES('d', '20040306 02:41:32')
> INSERT INTO #dts (c1, dt) VALUES('e', '20040315 11:45:17')
> INSERT INTO #dts (c1, dt) VALUES('f', '20040412 09:12:59')
> INSERT INTO #dts (c1, dt) VALUES('g', '20040523 11:43:25')
> However, when I search in both Northwind and Tempdb
> databases, I am not able to find it. I would like to know
> where is the Temporary Table being created ?
> Thanks|||Dear Hari,
I do find it by using your query.
In this way, if I want to make query of that temporary table, should I use
the table name dts?
Besides, you mention that temp tables are created every session, does it
mean that it will be deleted automatically at a specific time ? If yes, when
(Like - When I stop SQL Service) ?
Thanks
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eA7wxCZbFHA.3712@.TK2MSFTNGP09.phx.gbl...
> Hi,
> All the # (temp) tables and ## (global temp) table will be created in
> TEMPDB database. But for temp tables the name will be
> created with a unique prefix. This is because temp tables are created
> every session and each session a unqie table needs to be created.
> How to see this..
> Select name from tempdb..sysobjects where name like 'dts%'
> Thanks
> Hari
> SQL Server MVP
>
> "Peter" <anonymous@.discussions.microsoft.com> wrote in message
> news:0a0f01c56d8c$8f52e270$a401280a@.phx.gbl...
>|||Why bother about the physical name? Just use the temp table name you gave it
.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:0a0f01c56d8c$8f52e270$a401280a@.phx.gbl...
>I have created the following table in Northwind Database:
> CREATE TABLE #dts(c1 char(1), dt datetime)
> INSERT INTO #dts (c1, dt) VALUES('a', '20040305 09:12:59')
> INSERT INTO #dts (c1, dt) VALUES('b', '20040305 16:03:12')
> INSERT INTO #dts (c1, dt) VALUES('c', '20040306 00:00:00')
> INSERT INTO #dts (c1, dt) VALUES('d', '20040306 02:41:32')
> INSERT INTO #dts (c1, dt) VALUES('e', '20040315 11:45:17')
> INSERT INTO #dts (c1, dt) VALUES('f', '20040412 09:12:59')
> INSERT INTO #dts (c1, dt) VALUES('g', '20040523 11:43:25')
> However, when I search in both Northwind and Tempdb
> databases, I am not able to find it. I would like to know
> where is the Temporary Table being created ?
> Thanks|||Peter wrote:
> Dear Hari,
> I do find it by using your query.
> In this way, if I want to make query of that temporary table, should I use
> the table name dts?
Why not use the temp name (#dts)?

> Besides, you mention that temp tables are created every session, does it
> mean that it will be deleted automatically at a specific time ? If yes, wh
en
> (Like - When I stop SQL Service) ?
>
The table will be dropped as soon as the connection is closed.
Are you trying to access this table from a different connection?
If so, you might want a global temp as already specified ##TableName.
This should be available until the service is restarted.
The beauty of temp tables is they are localized to your current
connection so you can use them in a sp for instance and guarantee that
nothing else will disturb your temp table.
You might well be able to query the name from tempdb and then use it
'normally' but this would defeat the purpose of temp tables and could
well introduce some nasty side effects.
Cheers
JB

> Thanks
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:eA7wxCZbFHA.3712@.TK2MSFTNGP09.phx.gbl...
>
>

Location for Temporary File

I have created the following table in Northwind Database:
CREATE TABLE #dts(c1 char(1), dt datetime)
INSERT INTO #dts (c1, dt) VALUES('a', '20040305 09:12:59')
INSERT INTO #dts (c1, dt) VALUES('b', '20040305 16:03:12')
INSERT INTO #dts (c1, dt) VALUES('c', '20040306 00:00:00')
INSERT INTO #dts (c1, dt) VALUES('d', '20040306 02:41:32')
INSERT INTO #dts (c1, dt) VALUES('e', '20040315 11:45:17')
INSERT INTO #dts (c1, dt) VALUES('f', '20040412 09:12:59')
INSERT INTO #dts (c1, dt) VALUES('g', '20040523 11:43:25')
However, when I search in both Northwind and Tempdb
databases, I am not able to find it. I would like to know
where is the Temporary Table being created ?
ThanksHi,
All the # (temp) tables and ## (global temp) table will be created in TEMPDB
database. But for temp tables the name will be
created with a unique prefix. This is because temp tables are created every
session and each session a unqie table needs to be created.
How to see this..
Select name from tempdb..sysobjects where name like 'dts%'
Thanks
Hari
SQL Server MVP
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:0a0f01c56d8c$8f52e270$a401280a@.phx.gbl...
>I have created the following table in Northwind Database:
> CREATE TABLE #dts(c1 char(1), dt datetime)
> INSERT INTO #dts (c1, dt) VALUES('a', '20040305 09:12:59')
> INSERT INTO #dts (c1, dt) VALUES('b', '20040305 16:03:12')
> INSERT INTO #dts (c1, dt) VALUES('c', '20040306 00:00:00')
> INSERT INTO #dts (c1, dt) VALUES('d', '20040306 02:41:32')
> INSERT INTO #dts (c1, dt) VALUES('e', '20040315 11:45:17')
> INSERT INTO #dts (c1, dt) VALUES('f', '20040412 09:12:59')
> INSERT INTO #dts (c1, dt) VALUES('g', '20040523 11:43:25')
> However, when I search in both Northwind and Tempdb
> databases, I am not able to find it. I would like to know
> where is the Temporary Table being created ?
> Thanks|||In TempDB
Run the query after your creation
IF OBJECT_ID('tempdb..#dts') IS NOT NULL
PRINT 'TempDB'
ELSE
PRINT 'No'
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:0a0f01c56d8c$8f52e270$a401280a@.phx.gbl...
> I have created the following table in Northwind Database:
> CREATE TABLE #dts(c1 char(1), dt datetime)
> INSERT INTO #dts (c1, dt) VALUES('a', '20040305 09:12:59')
> INSERT INTO #dts (c1, dt) VALUES('b', '20040305 16:03:12')
> INSERT INTO #dts (c1, dt) VALUES('c', '20040306 00:00:00')
> INSERT INTO #dts (c1, dt) VALUES('d', '20040306 02:41:32')
> INSERT INTO #dts (c1, dt) VALUES('e', '20040315 11:45:17')
> INSERT INTO #dts (c1, dt) VALUES('f', '20040412 09:12:59')
> INSERT INTO #dts (c1, dt) VALUES('g', '20040523 11:43:25')
> However, when I search in both Northwind and Tempdb
> databases, I am not able to find it. I would like to know
> where is the Temporary Table being created ?
> Thanks|||Dear Hari,
I do find it by using your query.
In this way, if I want to make query of that temporary table, should I use
the table name dts?
Besides, you mention that temp tables are created every session, does it
mean that it will be deleted automatically at a specific time ? If yes, when
(Like - When I stop SQL Service) ?
Thanks
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eA7wxCZbFHA.3712@.TK2MSFTNGP09.phx.gbl...
> Hi,
> All the # (temp) tables and ## (global temp) table will be created in
> TEMPDB database. But for temp tables the name will be
> created with a unique prefix. This is because temp tables are created
> every session and each session a unqie table needs to be created.
> How to see this..
> Select name from tempdb..sysobjects where name like 'dts%'
> Thanks
> Hari
> SQL Server MVP
>
> "Peter" <anonymous@.discussions.microsoft.com> wrote in message
> news:0a0f01c56d8c$8f52e270$a401280a@.phx.gbl...
>>I have created the following table in Northwind Database:
>> CREATE TABLE #dts(c1 char(1), dt datetime)
>> INSERT INTO #dts (c1, dt) VALUES('a', '20040305 09:12:59')
>> INSERT INTO #dts (c1, dt) VALUES('b', '20040305 16:03:12')
>> INSERT INTO #dts (c1, dt) VALUES('c', '20040306 00:00:00')
>> INSERT INTO #dts (c1, dt) VALUES('d', '20040306 02:41:32')
>> INSERT INTO #dts (c1, dt) VALUES('e', '20040315 11:45:17')
>> INSERT INTO #dts (c1, dt) VALUES('f', '20040412 09:12:59')
>> INSERT INTO #dts (c1, dt) VALUES('g', '20040523 11:43:25')
>> However, when I search in both Northwind and Tempdb
>> databases, I am not able to find it. I would like to know
>> where is the Temporary Table being created ?
>> Thanks
>|||Why bother about the physical name? Just use the temp table name you gave it.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:0a0f01c56d8c$8f52e270$a401280a@.phx.gbl...
>I have created the following table in Northwind Database:
> CREATE TABLE #dts(c1 char(1), dt datetime)
> INSERT INTO #dts (c1, dt) VALUES('a', '20040305 09:12:59')
> INSERT INTO #dts (c1, dt) VALUES('b', '20040305 16:03:12')
> INSERT INTO #dts (c1, dt) VALUES('c', '20040306 00:00:00')
> INSERT INTO #dts (c1, dt) VALUES('d', '20040306 02:41:32')
> INSERT INTO #dts (c1, dt) VALUES('e', '20040315 11:45:17')
> INSERT INTO #dts (c1, dt) VALUES('f', '20040412 09:12:59')
> INSERT INTO #dts (c1, dt) VALUES('g', '20040523 11:43:25')
> However, when I search in both Northwind and Tempdb
> databases, I am not able to find it. I would like to know
> where is the Temporary Table being created ?
> Thanks|||Peter wrote:
> Dear Hari,
> I do find it by using your query.
> In this way, if I want to make query of that temporary table, should I use
> the table name dts?
Why not use the temp name (#dts)?
> Besides, you mention that temp tables are created every session, does it
> mean that it will be deleted automatically at a specific time ? If yes, when
> (Like - When I stop SQL Service) ?
>
The table will be dropped as soon as the connection is closed.
Are you trying to access this table from a different connection?
If so, you might want a global temp as already specified ##TableName.
This should be available until the service is restarted.
The beauty of temp tables is they are localized to your current
connection so you can use them in a sp for instance and guarantee that
nothing else will disturb your temp table.
You might well be able to query the name from tempdb and then use it
'normally' but this would defeat the purpose of temp tables and could
well introduce some nasty side effects.
Cheers
JB
> Thanks
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:eA7wxCZbFHA.3712@.TK2MSFTNGP09.phx.gbl...
>>Hi,
>>All the # (temp) tables and ## (global temp) table will be created in
>>TEMPDB database. But for temp tables the name will be
>>created with a unique prefix. This is because temp tables are created
>>every session and each session a unqie table needs to be created.
>>How to see this..
>>Select name from tempdb..sysobjects where name like 'dts%'
>>Thanks
>>Hari
>>SQL Server MVP
>>
>>"Peter" <anonymous@.discussions.microsoft.com> wrote in message
>>news:0a0f01c56d8c$8f52e270$a401280a@.phx.gbl...
>>I have created the following table in Northwind Database:
>>CREATE TABLE #dts(c1 char(1), dt datetime)
>>INSERT INTO #dts (c1, dt) VALUES('a', '20040305 09:12:59')
>>INSERT INTO #dts (c1, dt) VALUES('b', '20040305 16:03:12')
>>INSERT INTO #dts (c1, dt) VALUES('c', '20040306 00:00:00')
>>INSERT INTO #dts (c1, dt) VALUES('d', '20040306 02:41:32')
>>INSERT INTO #dts (c1, dt) VALUES('e', '20040315 11:45:17')
>>INSERT INTO #dts (c1, dt) VALUES('f', '20040412 09:12:59')
>>INSERT INTO #dts (c1, dt) VALUES('g', '20040523 11:43:25')
>>However, when I search in both Northwind and Tempdb
>>databases, I am not able to find it. I would like to know
>>where is the Temporary Table being created ?
>>Thanks
>>
>

locate static data in xml file vs db table

How do people see the security of locating static data (such as config
settings) in an XML file (a copy is located on each web-server, or a single
copy is located on a specific server) , versus locating this data inside the
db ?
An XML file that contains all app config settings is much easier to maintain
and track from the standpoint of source-code-control , and it is much easier
to apply changes to settings in production environments (just swap the XML
file and restart the web-servers).
The replication and other redudancy advantages accorded data inside SS are
not really necessary for static, load-on-app-start, config settings.
If not possible for data in an XML file to achieve the security of a data in
a db , one option would be to locate the XML file in a SS05 col of XML
datatype.
Anyone have real-world experience making this sort of trade-off decision ,
or any insights ?
Thanks.When did go through a similar exercise for our application. One of the
things that we considered was to look at configuration as something that is
"configurable". This means that the location of the configuration file
should be abstracted from your code so that you are free to move it around.
This is where the Configuration Application Block from Microsoft comes into
play:
http://msdn.microsoft.com/library/d...i
g.asp.
This block abstracts the ability to read and write from the configuration
file and from a deployment perspective, the configuration can be in XML or
in SQL Server. Maybe future editions of this block might put it in an SQL2K5
XML column, but the block would abstract it from you and you would always
have a consistent way of programming.
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"John A Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
news:OnfTXLs0FHA.3812@.TK2MSFTNGP09.phx.gbl...
> How do people see the security of locating static data (such as config
> settings) in an XML file (a copy is located on each web-server, or a
> single copy is located on a specific server) , versus locating this data
> inside the db ?
> An XML file that contains all app config settings is much easier to
> maintain and track from the standpoint of source-code-control , and it is
> much easier to apply changes to settings in production environments (just
> swap the XML file and restart the web-servers).
> The replication and other redudancy advantages accorded data inside SS are
> not really necessary for static, load-on-app-start, config settings.
> If not possible for data in an XML file to achieve the security of a data
> in a db , one option would be to locate the XML file in a SS05 col of XML
> datatype.
> Anyone have real-world experience making this sort of trade-off decision ,
> or any insights ?
> Thanks.
>|||Problem I see with Configuration Application Block is that it assumes only
the simplest data structure is needed for config settings: discrete named
values.
To get around this, you can write your own transformers. But to leverage the
advantages that CAB offers, you should write them to work against multiple
data-providers/data-stores). This is quite a bit of work -- might be better
to spend that time writing an app-specific solution from scratch.
Also, I think it's not a good idea to avoid upfront analysis of the
app-specific trade-offs between different data-store solutions. CAB seems to
be saying "avoid the tough design decision" ... and, in the process,
sacrifice the advantages offered by a custom design.
But maybe I'm mistaken ...
"SriSamp" <ssampath@.sct.co.in> wrote in message
news:O4Ervev0FHA.460@.TK2MSFTNGP15.phx.gbl...
> When did go through a similar exercise for our application. One of the
> things that we considered was to look at configuration as something that
> is "configurable". This means that the location of the configuration file
> should be abstracted from your code so that you are free to move it
> around. This is where the Configuration Application Block from Microsoft
> comes into play:
> http://msdn.microsoft.com/library/d...br />
fig.asp.
> This block abstracts the ability to read and write from the configuration
> file and from a deployment perspective, the configuration can be in XML or
> in SQL Server. Maybe future editions of this block might put it in an
> SQL2K5 XML column, but the block would abstract it from you and you would
> always have a consistent way of programming.
> --
> HTH,
> SriSamp
> Email: srisamp@.gmail.com
> Blog: http://blogs.sqlxml.org/srinivassampath
> URL: http://www32.brinkster.com/srisamp
> "John A Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
> news:OnfTXLs0FHA.3812@.TK2MSFTNGP09.phx.gbl...
>|||You're right in saying that CAB out of the box is for simple named values.
We have not tried writing our own formatters, thus, I cannot comment on the
complexity of the same. We did do an anslysis of an application specific
version, but found that the time it takes to provide a UI for the
configuration (like what CAB has) and the simple model of exposing the
configuration as properties of a class for our application looked like a
re-invention of the wheel.
Did you try posting your question to the GOTDOTNET site for Enterprise
Library? It is usually manned by the architects of the library and you may
get more specific answers.
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"John Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
news:O71N%23oz0FHA.2132@.TK2MSFTNGP15.phx.gbl...
> Problem I see with Configuration Application Block is that it assumes only
> the simplest data structure is needed for config settings: discrete named
> values.
> To get around this, you can write your own transformers. But to leverage
> the advantages that CAB offers, you should write them to work against
> multiple data-providers/data-stores). This is quite a bit of work --
> might be better to spend that time writing an app-specific solution from
> scratch.
> Also, I think it's not a good idea to avoid upfront analysis of the
> app-specific trade-offs between different data-store solutions. CAB seems
> to be saying "avoid the tough design decision" ... and, in the process,
> sacrifice the advantages offered by a custom design.
> But maybe I'm mistaken ...
> "SriSamp" <ssampath@.sct.co.in> wrote in message
> news:O4Ervev0FHA.460@.TK2MSFTNGP15.phx.gbl...
>

Locate backup file - can't see other drives

It's a two node cluster where only the E drive is in
the resource group. I suppose there isn't a way to have other drives
displayed when it's a clustered service.
Thanks a lot for the fast reply, now I don't have to scratch my head
anymore. Thanks John & Anthony aswell.
/lf
On Jul 6, 3:23 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> It could be that your SQL Server is clustered and you're seeing only the
> disks on which SQL Server has a dependency.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "lanfear" <v_ko...@.hotmail.com> wrote in message
> news:1183726609.006262.23360@.q75g2000hsh.googlegro ups.com...
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
|||Just got back from vacation - sorry for the late follow-up. I don't think
there is a way to get that in SSMS.
That said, I'm concerned that there is only one disk dependency - drive E: -
for your clustered instance. Typically, you have one disk for data and
another for logs.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"lanfear" <v_koski@.hotmail.com> wrote in message
news:1183732767.641961.258190@.q75g2000hsh.googlegr oups.com...
Wow, bullseye!

Locate backup file - can't see other drives

It's a two node cluster where only the E drive is in
the resource group. I suppose there isn't a way to have other drives
displayed when it's a clustered service.
Thanks a lot for the fast reply, now I don't have to scratch my head
anymore. Thanks John & Anthony aswell.
/lf
On Jul 6, 3:23 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> It could be that your SQL Server is clustered and you're seeing only the
> disks on which SQL Server has a dependency.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "lanfear" <v_ko...@.hotmail.com> wrote in message
> news:1183726609.006262.23360@.q75g2000hsh.googlegroups.com...
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!|||Just got back from vacation - sorry for the late follow-up. I don't think
there is a way to get that in SSMS.
That said, I'm concerned that there is only one disk dependency - drive E: -
for your clustered instance. Typically, you have one disk for data and
another for logs.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"lanfear" <v_koski@.hotmail.com> wrote in message
news:1183732767.641961.258190@.q75g2000hsh.googlegroups.com...
Wow, bullseye!

Locate backup file - can't see other drives

In MS SQL 2005 when you select "Restore Database" and click "From
Device", you get a directory explorer where you can select a backup
file. In that explorer window ("Locate Backup File") I can't see any
other drives than the one where my MS SQL Server is installed.
Is it just my system or is this by design?
Thanks for any ideas!It could be that your SQL Server is clustered and you're seeing only the
disks on which SQL Server has a dependency.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"lanfear" <v_koski@.hotmail.com> wrote in message
news:1183726609.006262.23360@.q75g2000hsh.googlegroups.com...
In MS SQL 2005 when you select "Restore Database" and click "From
Device", you get a directory explorer where you can select a backup
file. In that explorer window ("Locate Backup File") I can't see any
other drives than the one where my MS SQL Server is installed.
Is it just my system or is this by design?
Thanks for any ideas!|||Hi
"lanfear" wrote:
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
>
Normally the dialog would default to a location and you could browse from
there depending on your permissions to see the directories. You could try
typing the path in yourself. With a cluster you would only see the drives
that have been tagged as cluster resources.
John|||Are the other drives in question local? I
--
Anthony E. Castro - MCDBA
"lanfear" wrote:
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!
>|||Wow, bullseye! :) It's a two node cluster where only the E drive is in
the resource group. I suppose there isn't a way to have other drives
displayed when it's a clustered service.
Thanks a lot for the fast reply, now I don't have to scratch my head
anymore. Thanks John & Anthony aswell.
/lf
On Jul 6, 3:23 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> It could be that your SQL Server is clustered and you're seeing only the
> disks on which SQL Server has a dependency.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "lanfear" <v_ko...@.hotmail.com> wrote in message
> news:1183726609.006262.23360@.q75g2000hsh.googlegroups.com...
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!|||Just got back from vacation - sorry for the late follow-up. I don't think
there is a way to get that in SSMS.
That said, I'm concerned that there is only one disk dependency - drive E: -
for your clustered instance. Typically, you have one disk for data and
another for logs.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"lanfear" <v_koski@.hotmail.com> wrote in message
news:1183732767.641961.258190@.q75g2000hsh.googlegroups.com...
Wow, bullseye! :) It's a two node cluster where only the E drive is in
the resource group. I suppose there isn't a way to have other drives
displayed when it's a clustered service.
Thanks a lot for the fast reply, now I don't have to scratch my head
anymore. Thanks John & Anthony aswell.
/lf
On Jul 6, 3:23 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> It could be that your SQL Server is clustered and you're seeing only the
> disks on which SQL Server has a dependency.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> "lanfear" <v_ko...@.hotmail.com> wrote in message
> news:1183726609.006262.23360@.q75g2000hsh.googlegroups.com...
> In MS SQL 2005 when you select "Restore Database" and click "From
> Device", you get a directory explorer where you can select a backup
> file. In that explorer window ("Locate Backup File") I can't see any
> other drives than the one where my MS SQL Server is installed.
> Is it just my system or is this by design?
> Thanks for any ideas!

Monday, March 12, 2012

localized messages for SQL SERVER 2000

I found a usefull link to my problem : http://support.microsoft.com/Default.aspx?id=277535

But I am unable to find the s80xLang.exe file anywhere. I have looked through all my DVDs and nothing.

Anyone know where to look or download it from ?

The KB article mentions that you need to contact Customer Support to be able to download this. That wording implies the file is not available for public download. If you use email support to open a case with CSS, I'm pretty sure they will either send the file to you or provide you with the path to the download.|||

All the developper email contacts costs money for support. I called support and they gave me the same response : I need to give a credit card to the routing agent and the support tech will decide if it's free or not after we resolve the issue. I have sent an email through our partner account and am waiting for a response.

I noticed that a lot of people are looking for an answer on this topic.

|||

Anyone has had success in obtaining the localization s80xLang.exe file?

What's the point of Microsoft for not making this file public (or better, include it on the original product CD)?

|||

Hi Antonio,

I finally called microsoft with our partner ID because we have so many free calls per year we can use. After speaking to a SQL specialist, he sent me the file. They were supposed to make the file public on the web site (it's available for them internally) but not for the rest of us.

You can give them a call and they will send you the file. I was not charged for the support call since it's their mistake.

Good luck and take care

|||

All right, I've got the localization file (thanks, Marco!).... only to discover that it doesn't work with SQLServer 2005!

The problem is:

1 - for the script to run it must have permission to update the system table sysmessage;

2 - up to SQL 2000 this was achieved by issuing "sp_configure 'allow updates',1" or starting SQL with the -m option;

3 - SQL 2005 explicity states that updates to system tables are not allowed and that "sp-configure allow updates" is outdated and won't work (http://msdn2.microsoft.com/en-us/library/ms144262.aspx). Running the script in single-user mode (starting SQL with the -m option) doesn't work either, since "updates to system tables are not allowed".

Any ideas or further help will be appreciated.

Regards,

Antonio Plais - Brazil

|||

Further developments on localizing SQL 2005 messages:

1 - I'm developing an application using SQL Express 2005, and I'd like to show SQL messages in Brazilian Portuguese (one of the SQL 2005 supported languages);

2 - The solution pointed by Microsoft support doesn't work on SQL 2005;

3 - Localized Brazilian SQL Express 2005 Standard can be downloaded from Microsoft, while SQL Express 2005 Advanced is available only in English;

4 - Standard edition doesn't install full-text search; trying to install it from Advanced edition (after installing the Brazilian standard version) doesn't work;

5 - So, until Microsoft gently makes available a Brazilian Advanced version, I'll have to choose between localized messages or full-text search;

How hard Microsoft can make our lives!

Regards,

Antonio Plais - Brazil

localized messages for SQL SERVER 2000

I found a usefull link to my problem : http://support.microsoft.com/Default.aspx?id=277535

But I am unable to find the s80xLang.exe file anywhere. I have looked through all my DVDs and nothing.

Anyone know where to look or download it from ?

I noticed that a lot of people are looking for an answer on this topic.

|||

Anyone has had success in obtaining the localization s80xLang.exe file?

What's the point of Microsoft for not making this file public (or better, include it on the original product CD)?

|||

Hi Antonio,

You can give them a call and they will send you the file. I was not charged for the support call since it's their mistake.

Good luck and take care

|||

All right, I've got the localization file (thanks, Marco!).... only to discover that it doesn't work with SQLServer 2005!

The problem is:

1 - for the script to run it must have permission to update the system table sysmessage;

2 - up to SQL 2000 this was achieved by issuing "sp_configure 'allow updates',1" or starting SQL with the -m option;

Any ideas or further help will be appreciated.

Regards,

Antonio Plais - Brazil

|||

Further developments on localizing SQL 2005 messages:

1 - I'm developing an application using SQL Express 2005, and I'd like to show SQL messages in Brazilian Portuguese (one of the SQL 2005 supported languages);

2 - The solution pointed by Microsoft support doesn't work on SQL 2005;

3 - Localized Brazilian SQL Express 2005 Standard can be downloaded from Microsoft, while SQL Express 2005 Advanced is available only in English;

4 - Standard edition doesn't install full-text search; trying to install it from Advanced edition (after installing the Brazilian standard version) doesn't work;

5 - So, until Microsoft gently makes available a Brazilian Advanced version, I'll have to choose between localized messages or full-text search;

How hard Microsoft can make our lives!

Regards,

Antonio Plais - Brazil

Wednesday, March 7, 2012

Local Report Processing mode

Hi,
We have a scenario where we want to test the <a href> url generated
by parsing the <Hyperlink> element present in the rdl file
This check needs to be done without deploying the rdl file on the
report server. So we are planning to use Local processing mode of the
report view control.
I wanted to ask on whether there are any differences between the
conversion of <Hyperlink> element to <a href> when checked in local
processing mode and when checked in remote processing mode (i.e when
the conversion is done by report server by using reporting server web
services).
Thanks in advancewhat do you mean by "test the <a href>?
do you want to validate that the URL works fine before deploying the report?
the local processing mode of the report viewer can't use an RDL file. you
have to convert it to RDLC. but you also have to execute the query in your
code.
the report viewer just render the report and can't execute the query
statements.
but...
you can validate the hyperlink objects in the RDL file
directly, if the hyperlink is hardcoded. (you can simply use the XML
Document object model to do this)
another option is to publish the report in report server, then execute the
report by code and retrieve the URLS generated in the HTML content to
validate them.
hope this will help you.
"Amit" <amits.84@.gmail.com> wrote in message
news:1182624675.249537.176170@.x35g2000prf.googlegroups.com...
> Hi,
> We have a scenario where we want to test the <a href> url generated
> by parsing the <Hyperlink> element present in the rdl file
> This check needs to be done without deploying the rdl file on the
> report server. So we are planning to use Local processing mode of the
> report view control.
> I wanted to ask on whether there are any differences between the
> conversion of <Hyperlink> element to <a href> when checked in local
> processing mode and when checked in remote processing mode (i.e when
> the conversion is done by report server by using reporting server web
> services).
> Thanks in advance
>|||Thanks for the reply.
I want to validate 2 things with the Hyperlink element which would
contain complex expressions and calls to custom assemblies.
1. Whether the rdl file deploys correctly
2. Whether the url generated is right
This needs to be done without any interaction with the report server.
Hence we wanted to try out local report processing mode. Can you
please guide whether I will be able to validate the above mentioned
scenarios using local processing mode ?
For validating the second scenario I would need to generate an event
of clicking the hyperlink. Is that possible in local report processing
mode ?
I will convert the rdl file to rdlc file. As only <Hyperlink>
scenarios needs to be test I would create a rdl file which contains
only <Hyperlink> element. Renaming this rdl file to rdlc would work as
the schema for both are same. right ?
On Jun 24, 2:33 am, "Jeje" <willg...@.hotmail.com> wrote:
> what do you mean by "test the <a href>?
> do you want to validate that the URL works fine before deploying thereport?
> thelocalprocessingmodeof thereportviewer can't use an RDL file. you
> have to convert it to RDLC. but you also have to execute the query in your
> code.
> thereportviewer just render thereportand can't execute the query
> statements.
> but...
> you can validate the hyperlink objects in the RDL file
> directly, if the hyperlink is hardcoded. (you can simply use the XML
> Document object model to do this)
> another option is to publish thereportinreportserver, then execute thereportby code and retrieve the URLS generated in the HTML content to
> validate them.
> hope this will help you.
> "Amit" <amits...@.gmail.com> wrote in message
> news:1182624675.249537.176170@.x35g2000prf.googlegroups.com...
> > Hi,
> > We have a scenario where we want to test the <a href> url generated
> > by parsing the <Hyperlink> element present in the rdl file
> > This check needs to be done without deploying the rdl file on the
> >reportserver. So we are planning to useLocalprocessingmodeof the
> >reportview control.
> > I wanted to ask on whether there are any differences between the
> > conversion of <Hyperlink> element to <a href> when checked inlocal
> >processingmodeand when checked in remoteprocessingmode(i.e when
> > the conversion is done byreportserver by using reporting server web
> > services).
> > Thanks in advance|||All the above testing scenarios should be done programmatically.
On Jun 24, 6:47 pm, Amit <amits...@.gmail.com> wrote:
> Thanks for the reply.
> I want to validate 2 things with the Hyperlink element which would
> contain complex expressions and calls to custom assemblies.
> 1. Whether the rdl file deploys correctly
> 2. Whether the url generated is right
> This needs to be done without any interaction with thereportserver.
> Hence we wanted to try outlocalreportprocessingmode. Can you
> please guide whether I will be able to validate the above mentioned
> scenarios usinglocalprocessingmode?
> For validating the second scenario I would need to generate an event
> of clicking the hyperlink. Is that possible inlocalreportprocessingmode?
> I will convert the rdl file to rdlc file. As only <Hyperlink>
> scenarios needs to be test I would create a rdl file which contains
> only <Hyperlink> element. Renaming this rdl file to rdlc would work as
> the schema for both are same. right ?
> On Jun 24, 2:33 am, "Jeje" <willg...@.hotmail.com> wrote:
> > what do you mean by "test the <a href>?
> > do you want to validate that the URL works fine before deploying thereport?
> > thelocalprocessingmodeof thereportviewer can't use an RDL file. you
> > have to convert it to RDLC. but you also have to execute the query in your
> > code.
> > thereportviewer just render thereportand can't execute the query
> > statements.
> > but...
> > you can validate the hyperlink objects in the RDL file
> > directly, if the hyperlink is hardcoded. (you can simply use the XML
> > Document object model to do this)
> > another option is to publish thereportinreportserver, then execute thereportby code and retrieve the URLS generated in the HTML content to
> > validate them.
> > hope this will help you.
> > "Amit" <amits...@.gmail.com> wrote in message
> >news:1182624675.249537.176170@.x35g2000prf.googlegroups.com...
> > > Hi,
> > > We have a scenario where we want to test the <a href> url generated
> > > by parsing the <Hyperlink> element present in the rdl file
> > > This check needs to be done without deploying the rdl file on the
> > >reportserver. So we are planning to useLocalprocessingmodeof the
> > >reportview control.
> > > I wanted to ask on whether there are any differences between the
> > > conversion of <Hyperlink> element to <a href> when checked inlocal
> > >processingmodeand when checked in remoteprocessingmode(i.e when
> > > the conversion is done byreportserver by using reporting server web
> > > services).
> > > Thanks in advance|||converting an RDL file to RDLC + code based dataset execution could be
possible, but complicated regarding your development constraints.
also, testing a report should be done 1 time only, after this you can't test
all the cases (I mean you can't test all the possible resultsets coming from
the database)
So, I recommend to spread your code in 2:
1. predeploy testing
2. deploy
the step 1 can be done by deploying the report in a test report server or an
hidden folder in RS. when you publish a report the publish process returns
the warnings and other errors found in the report. (so you can stop the
process here if there is warning, and if there is errors the report is not
deployed)
When this step pass the deployment, you can now execute the report a first
time and scan the resulting HTML content by code.
so you can retrieve all the <a href statements and verify by code if these
links works fine (using the webrequest object in .NET)
and finally, remove the tested report from report server.
now the report is approved for deployment and can be added in your
deployment process.
converting an RDL report to RDLC can be complex because you have to extract
the SQL queries and connections from the report, create and populate a
dataset on the fly and execute the report on the fly. what's appends if
there is parameters?
you can't simulate a direct "click" event on an hyperlink in any scenario.
you can just extract and test the generated HTML content.
but can you explain who creates the reports and how?
because Visual Studio can validate the deployment himself and can "compile"
the report to identify warnings and errors.
also, can you explain how the hyperlinks are created in the reports?
does it's hardcoded (fixed) links? or does the links come from a database?
or does the links is a formula result? (a concatenation of something like:
"http://myserver/myfolder/mypage.aspx?id=" & Datasetfield.Value)
Jerome.
"Amit" <amits.84@.gmail.com> wrote in message
news:1182692843.900480.295280@.e16g2000pri.googlegroups.com...
> Thanks for the reply.
> I want to validate 2 things with the Hyperlink element which would
> contain complex expressions and calls to custom assemblies.
> 1. Whether the rdl file deploys correctly
> 2. Whether the url generated is right
> This needs to be done without any interaction with the report server.
> Hence we wanted to try out local report processing mode. Can you
> please guide whether I will be able to validate the above mentioned
> scenarios using local processing mode ?
> For validating the second scenario I would need to generate an event
> of clicking the hyperlink. Is that possible in local report processing
> mode ?
> I will convert the rdl file to rdlc file. As only <Hyperlink>
> scenarios needs to be test I would create a rdl file which contains
> only <Hyperlink> element. Renaming this rdl file to rdlc would work as
> the schema for both are same. right ?
> On Jun 24, 2:33 am, "Jeje" <willg...@.hotmail.com> wrote:
>> what do you mean by "test the <a href>?
>> do you want to validate that the URL works fine before deploying
>> thereport?
>> thelocalprocessingmodeof thereportviewer can't use an RDL file. you
>> have to convert it to RDLC. but you also have to execute the query in
>> your
>> code.
>> thereportviewer just render thereportand can't execute the query
>> statements.
>> but...
>> you can validate the hyperlink objects in the RDL file
>> directly, if the hyperlink is hardcoded. (you can simply use the XML
>> Document object model to do this)
>> another option is to publish thereportinreportserver, then execute
>> thereportby code and retrieve the URLS generated in the HTML content to
>> validate them.
>> hope this will help you.
>> "Amit" <amits...@.gmail.com> wrote in message
>> news:1182624675.249537.176170@.x35g2000prf.googlegroups.com...
>> > Hi,
>> > We have a scenario where we want to test the <a href> url generated
>> > by parsing the <Hyperlink> element present in the rdl file
>> > This check needs to be done without deploying the rdl file on the
>> >reportserver. So we are planning to useLocalprocessingmodeof the
>> >reportview control.
>> > I wanted to ask on whether there are any differences between the
>> > conversion of <Hyperlink> element to <a href> when checked inlocal
>> >processingmodeand when checked in remoteprocessingmode(i.e when
>> > the conversion is done byreportserver by using reporting server web
>> > services).
>> > Thanks in advance
>

Friday, February 24, 2012

local database in c#

Hi,

I want to create a database in a path specified by the user at runtime when he selects a menu item like File/New. My preference is to not require the user to run an sql server on his machine to run my application. All my searches on the web for this keep directing me to the code that creates a database on an sql server but I don't want that. I want the application to create the database at runtime at a place where the user chooses. I would appreciate either a snippet of code or a link to somewhere helpful please.

Hi,

MS Access is the solution for u. It does not require any extra files to work. It just need MDAC to be installed and it's shipped with Windows.

All u have to do is to create ure database with all tables, views,... with no data. Ship the empty database with ure application and when the user wants to create a new database u just copy the empty database to the user location.

HTH.

Hayder Marzouk

|||Thanks Hayder.

If there is a way to do this with a local sql database, I would appreciate some sample code to see how to do it.
|||

Hi,

You may create a T-SQL script and then run the script to create a database.

Move from C# express forum to Sql server forum.

Thanks

|||

Not within your specified 'requirements'

My preference is to not require the user to run an sql server on his machine to run my application.

A 'Local' sql database will require that the user run or have access to a SQL Server.

As Hayder mentioned, an Access database is an excellent option and does not require that the user have access to, or install a SQL Server.

Local cubes connection

Hello,
I have created 3 local cubes which resided in the same .cub file. The cubes created from AS 2005 cubes.
How can I make ADOMD connection to all 3 cubes at the same time in my client application (C#)?
The problem is that Initial Catalog (database name) in connection string in case of local cubes is the same as the cube name.

Thanks,
GB

In ADOMD you don't connect directly to any specific cube. Once you have connect to the database (catalog) you just specify which cube you want in the query. So you only need the one connection and you can use that to query any of the cubes in the catalog.

SELECT measures.AllMembers ON COLUMNS FROM <CUBE_NAME>

|||

I think GB meant that the problem was that since for him database name and the cube name are the same - he ended up with 3 different databases, and ADOMD only works with one database at the time.

However, the limitation of database name being the same as the cube name only existed in AS2000, and also AS2000 officially only supports one cube per database. These limitations don't exist in AS2005.

|||That makes sense, If I had to create a local cube I would use the ASSL syntax, but if I am not mistaken the CREATE LOCAL CUBE (which is depreciated) and CREATE GLOBAL CUBE methods setup the database with the same name as the cube. There is a reasonable white paper on local cubes which contrasts the different methods of creating them here http://www.localcubetask.com/UsingLocalCubesinMicrosoftSQLServer2005AnalysisServices.doc|||

I have cteated my local cubes using ASSL CGC method in SSMS 2005.

I created 3 cubes: Cube1,Cube2,Cube3 in one My_cubes.cub file.

In my C# code application I have the following connection string:

string myConnectionString = "Provider=MSOLAP;Data Source='C:\\LOCALCUBES\\My_cubes.cub';Initial Catalog=Cube1";

When I try to get dimensions from Cube2 I 'v got an error related to the connection string - no connection to Cube2.

I tryed to create 2 saparate connection strings for the same My_cubes.cub file but different cubes, but application can not open same file twice.

So, I still have a problem to open connection to 2 local cubes at the same time.

Thanks,

|||The solution that was suggested above, is to build real XMLA scripts to create your cubes instead of using CREATE GLOBAL CUBE statement - this way you will be able to put multiple cubes in the same database in the local cube.|||

Yes, XMLA script is working for me.

I found the instructions hear:

http://cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!883.entry

Thanks,

|||

Still have the problem.

My local .cub file created by XMLA script contains 3 databases with 7 cubes each.

When I open this .cub file in MDX Sample application I can make

a connection and MDX query to any of 3 databases and accordingly their cubes.

But in my C# application when I try open connection to all local databases in a loop from the same .cub file

I got the error just after attampting to open second database in a loop.This is ADOMDClient.AdomdConnection error:

"A connection cannot be made. Ensure that the server is running".

Any hints how to fix the problem?

Thanks,

|||

You can only have one connection to the local cube file - therefore the second connection fails. Your options:

1. Split it to the 3 different local cube files

2. Put all the cubes in the same database

3. Close the previous connection before opening a new one

4. Keep one connection, but change the current database when you need to go to another one.