I downloaded and registered Visual Studio Express Edition. I got this nice email back with links to demos, tutorials, and starter kits. Unfortunately, the links to most of the starter kits are broken. Can I still get these things?
Hi everyone,
Is there somewhere that I can change the links that are included in subscription emails? The link that goes out is incorrect because the port number of the server is not included in the link, so I'd like to edit this. Does anyone know where this can be done? Thank you!
-Keith
Hi,
I was trying to download SQL Server Management Studio Express from http://msdn.microsoft.com/vstudio/express/sql/download/default.aspx. The links on this page seem to be broken.
I tried to download the Mgmt Studio Express by clicking on a link that points to http://go.microsoft.com/fwlink/?LinkId=65110.
Anyone else facing this issue? Is there another place I can get SQL Server Management Studio Express from?
How do you make a live link in SQL 7 to another database? I currently do such
things in Access 97 but how do you do it in SQL? I just want to keep a permanent live link to a table in another database.
Thank you in advance.
Thanks in advance!
I am new to SQL Server Development. I will be working on a project which requires a good understanding of SSIS. What are the usual scenarios or tasks I will be given when working on SSIS? Please help!!
Is there a way of searching tables and linking to the relationship used.
I need to find a list of tutors and the session they teach (both available in a session table)
i then need to find the list of members that are enrolled onto each session.
In the session table the relationship allows me to view what members are on each session but i cannot find a code that allows me to see what tutors teach what session and what members attend these lessons.
I spoke to my tutor who did not offer too much help but did say it may be possible to use the "AND" function
Have good grasp of mdb's. Beginner with sqlHave sql db of charity organisations with contact details, all fairlysimple. Have one Field for web addresses entered www.xxxxx.co.uk anotherfor emails entered aaaa@bbbb. Unable to work out how to make these active.Its certainly not like mdb's!Created Page with dropdown list which when clicked gives details ofselected charity. Want the above 2 entries 'live'.Any help from the collective intelligence would be gratefully received.Graham
View 2 Replies View RelatedHi
I have a problem, when i do a select records from the production server which is situated in melbourne,around 20,000 records need to be fetched but sunddenly after 13,000 records the connection is broken
why is this heppening
what is the cause for this
how to overcome this
pls let me know asap with the evidence
thanks
venkat
Hi ,
I am running a process from from my client having TCP/IP sockets connected to WIN NT sql server 7.0. I get a error msg [MICROSOFT][ODBC SQL SERVER DRIVER][TCP/IP SOCKETS]ConnectionCheckForData (null())).
Connection Broken .
The same thing happened in other NT SQL server as well,but it is ran o.k if i run from the server itself. Checked Microsoft documents they advised me to use Named Pipes and to check the client and server network utility. Check every detail but still facing same errors. Can anyone provide an solution for this.
Thanks,
Venkat.
As we have just got SQL at work I had decided to play with SQL on my home computer to find out what made it tick.
I am using the 120 day demo enterprise version. While playing in the user accounts area (under security) I denied access to the database on the guest account (like you disable the guest account on domain logins) and (if you have not guessed already) I can't get access to the server anymore. I did try reinstalling but I guess that there are still some settings in the registry that don't get deleted. Any suggestions how I can get back in.
My PC at home is a XP home edition, no domain etc. SQL was installed onto the PC and I was accessing (playing with it on this PC). The setup I was playing with has no data (except what comes with the SQL) so I am not worried about losing anything.
Thanks in advance
Tim
Hi All,
When I run this statement it gives me an error.:
CREATE
INDEX [NC_DateAcctTotal] ON [dbo].[BilledPackages] ([pu_date], [acct_no], [delete_flag], [billing_weight_charge])
WITH
FILLFACTOR = 90
ON [PRIMARY]
::::: ERROR ::::
Server: Msg 823, Level 24, State 2, Line 1
I/O error (torn page) detected during read at offset 0x000006d5f2c000 in file 'E:MSSQLDataManagement_Data2_Data.NDF'.
Connection Broken
Thanks!
Aric
I am trying to set up a filtered paging ObjectDataSource for a gridvoew control.
My code works, my query doesn't...
This is OK: Get all rows of data:
"SELECT UCO, country_code, country_name, enabled, concurrency FROM CountryCodes "
Returns all records as expected
This is OK: Getting rows of data with no Filter:
"SELECT UCO, country_code, country_name, enabled, concurrency FROM (SELECT ROW_NUMBER() OVER (ORDER BY country_name ) As Row, UCO, country_code, country_name, enabled, concurrency FROM CountryCodes ) As TempRowTable WHERE Row >= 0 AND Row <= 10"
Returns expected data
This is OK: Making sure my WHERE filter works:
"SELECT UCO, country_code, country_name, enabled, concurrency FROM CountryCodes WHERE country_name LIKE '%u%' "
Returns 85 records
This is BROKEN!!!: I want to return 10 rows of filtered data:
"SELECT UCO, country_code, country_name, enabled, concurrency FROM (SELECT ROW_NUMBER() OVER (ORDER BY country_name ) As Row, UCO, country_code, country_name, enabled, concurrency FROM CountryCodes ) As TempRowTable WHERE ( Row >= 0 AND Row <= 10 ) AND ( country_name LIKE '%u%' ) "
It Returns 0 records!!!
What am I doing wrong in the last query?
Or even better how do I fix it?
Thanks,
Roger
Anyone having problems with this forum today?
I have had countless email alerts thru today alerting me to people replying to threads I have commented on. And I can see the person's comments.
1) WhenI click on the link it takes me to a page saying the post doesn't exist
2) When I try and browse to the thread manually I can't see the reply.
3) On one occasion I replied to one of these threads asking if someone had posted something and then deleted it. After I submitted the post I could see all the other posts in the thread which were supposedly missing before. The next time I browse to the thread (in a new browser window) I can't see any of the posts.
BROKEN!!!! I for one won't be coming back here until they fix it. Its pathetic.
I have posted something on the bug report forum by the way.
-Jamie
P.S. Its not just on this forum either.
hello,
I look for establish between 2 databases on the same SQL server in a query ?
How can I do this ?
Thanks,
Nixo
hello,
I look for establish a link from a external database to my SQL database ...
How can I do this ?
Thanks,
NIxo
I need some links which guide datetime in sql statement !!
Such as : I have a datetime column in my table , I need to calculate
the total orders in the today, or yesterday ...
Any one know ?
Thank you very much .
hi, i have headers at the top of my list and would like for people to click the pubs link and it orders the pubs alphabetically descending and when they click again to ascend also to do this with towns and addresses and postcodes?!
can someone please help?
J x
can anybody give me some nice links with a detailed explaination of the various replication errors and solution
thanks in advance
Jacx
Not sure where to place this question...
We have a bunch of SQL databases that are used for a similar number of IIS sites (we are talking of close to 500 sites), dealing with a .NET e-learning application
While we manage to create a virtual folder for the e-learning content, we do have one database for each site. So, when it comes to update the whole platform, we are talking about running one script per site, which may take about 5 seconds per user per site. With a total of 300.000 users and sites, it may come to more than 17 days running the update script.
Is there a way similar to that on IIS to create a symbolic link from one table in one database to another table in a diferent database in a diferent or same server?
Thanks,
AG
I have a Summary page on a report and then a detail page. FOr eg on the summary pg, I have a field called 'Name'. eg summary will be on name ie 'A', B, C ETC.. When the user clicks on the summary name ie A, he should be able to directly go to that details for that particular name ie details of 'A'.
How can I achieve this, will be probably thr parameters, but not sure how.
Hi:
While performing a restore, one of the transaction logs was apparently corrupt. So the database gets partially restored with an error saying :
Backup or restore operation successfully processed 1 pages in 0.505 seconds Processed 6 pages for database 'royal', file 'royal_Log' on file 1.
Server: Msg 9004, Level 21, State 2, Line 1
The log for database ' ' is corrupt.
ODBC: Msg 0, Level 16, State 1
Communication link failure
Can anyone give me some tips how to restore? any help appreciated.
bye
Eva
Hi there, wasn't quite sure where to put this but I still regard myself as a bit of an SQL Server noob so thought it'd be ok here....hopefully?! lol
Right....I have a database called CDR and a Login set up for this on the server called CDMLogin. The CDR database is a non-live backup of another database stored elsewhere. In order to update this for testing purposes I needed to make a backup of the live database and then do a 'restore database' over the top of the old CDR one. This has worked fine before.....however, on this occasion, the link between the CDR database and the CDMLogin appears to have been broken. I have since read about how this can be an issue when restoring databases but I have still not found a fix. Any ideas?
Thanks v much
Version: Microsoft SQL Server 2000 - 8.00.2040 (Intel X86)
Problem:
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 515532920. The text, ntext, or image node at page (1:377289), slot 1, text ID 897099563008 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 515532920. The text, ntext, or image node at page (1:377447), slot 1, text ID 897100939264 is not referenced.
<... and 4 same errors>
DBCC results for 'CC_Document'.
The repair level on the DBCC statement caused this repair to be bypassed.
<same messages>
The repair level on the DBCC statement caused this repair to be bypassed.
There are 192 rows in 6 pages for object 'CC_Document'.
CHECKTABLE found 0 allocation errors and 8 consistency errors in table 'CC_Document' (object ID 515532920).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (crmproded.dbo.CC_Document repair_fast).
I won't run checktable with 'repair_allow_data_loss' before all records aren't find out
I try run DBCC PAGE on this pages. It print info
PAGE: (1:377289)
----------------
BUFFER:
-------
BUF @0x01249540
---------------
bpage = 0x2928A000 bhash = 0x00000000 bpageno = (1:377289)
bdbid = 8 breferences = 0 bstat = 0x9
bspin = 0 bnext = 0x00000000
PAGE HEADER:
------------
Page @0x2928A000
----------------
m_pageId = (1:377289) m_headerVersion = 1 m_type = 3
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x8000
m_objId = 515532920 m_indexId = 255 m_prevPage = (0:0)
m_nextPage = (0:0) pminlen = 0 m_slotCnt = 2
m_freeCnt = 3742 m_freeData = 4446 m_reservedCnt = 0
m_lsn = (19116:290571:12) m_xactReserved = 0 m_xdesId = (0:0)
m_ghostRecCnt = 0 m_tornBits = 856438469
Allocation Status
-----------------
GAM (1:2) = ALLOCATED SGAM (1:3) = NOT ALLOCATED
PFS (1:372048) = 0x42 ALLOCATED 80_PCT_FULL DIFF (1:6) = NOT CHANGED
ML (1:7) = NOT MIN_LOGGED
Blob fragment at: Page (1:377289) Slot 0 Length: 4266 Type: 3 (DATA)
Blob Id:897099563008
2928A06E: 7fe8108f 64a115ed 245a1a1a b68e502c .......d..Z$,P..
<blob fragment ... >
2928B0FE: 00006278 00006e87 00007ad1 xb...n...z..
Blob fragment at: Page (1:377289) Slot 1 Length: 84 Type: 4 (LARGE_ROOT_2)
Blob Id: 897099563008 Level: 0 MaxLinks: 5 CurLinks: 5
Child fragment at Page (1:377237) Slot 0 Offset: 8080
Child fragment at Page (1:377238) Slot 0 Offset: 16160
Child fragment at Page (1:377239) Slot 0 Offset: 24240
Child fragment at Page (1:377288) Slot 0 Offset: 32320
Child fragment at Page (1:377289) Slot 0 Offset: 36572
There are 5 links at Slot 1 , that's generate error. But why? What does it mean - "The text, ntext, or image node at page (1:377289), slot 1, text ID 897099563008 is not referenced" ???
I saw other pages (not 'broken') - there is: Blob Fragment don't contains links - links are in other pages.
What are these 'broken' records in my example - they are chunks of lost information, that i can't recover?
Or not? May be exists a way, that i find all 'broken' records? Because, my table contains 192 records. But there is BLOB field - and i can't check consistency of every file, that uploaded in my table. In addition I will fully appreciate this problem.
At last, if i find record, i run checktable with repair_allow_data_loss, then upload file again.
p.s. These errors contained in backup too.
I have a SSIS which have a user string variable named connectionstring. In the package definition it has empty value. But in my package.dtsconfig file I set the value of this variable.
But I am not getting the value inside a script component. I tried debugging with a msgbox echoing the variable value ... but I see only empty value i.e. at runtime the value is not being read from config file
What can be wrong here?
next if I put the value ("Data Source=<Server>;Initial Catalog=<Database>;Integrated Security=True;") in the variable definition itself I get the following error
[Execute SQL Task] Error: Failed to acquire connection "<ADO Connection>". Connection may not be configured correctly or you may not have the right permissions on this connection.
The SSIS was running fine previously ... it broke after I updated by machine with the latest windows updates today.
I am working on a 64 bit Windows 2003 SP1 Server box with Visual Studio 2005 SP1, SQL Server 2005 SP1
Hi,
Our vertical market applicaiton uses connection strings to connect to SQL 2005.
.NET 2.0 SP1 was auto updated on one of our machines
Connection strings are now failing (doesn't return -1 but doesn't connect).
Can anyone help?
I'm really nervoust that on Monday 1200 angry customers are going to call.
Hi,
I have made a chart that displays data for my company. However, when I have the report.rdl on the "live" serverand use the "live" data source, I can't get the report manager to display the chart, only the famuos x of a broken image link. If I place the report.rdl on the test server and use the "live" data source the chart is displayed.
What is the difference between having the report on the test server versus the "live" server?
Report manager -> report on test server -> live data source = working
Report manager -> report on "live" server -> live data source = no image
I dont think the problem is sequrity related, but I dont know for sure...
Thanks in advance!
Niklas
I have a problem with copying data over a db-link. When running the transaction in Query Analyzer it works fine, but when running it via a package, I get the following error-message. Has anyone a solution to this problem ???
Server: Msg 7391, Level 16, State 1, Line 3
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
Can someone tell me good books or links for Report services?
View 1 Replies View RelatedIs this possible to do using regular expressions in sql 2005?
View 1 Replies View RelatedWe have replication successfully running but when I tried to set up a new test instance on completely different servers (Server A to Server B, say) the push agent to create the susbcription on Server B complains
'Could not find server 'Server C' in sysservers. Execute sp_addlinkedserver. . . .'
Server C was never configured as a subscriber for the publication in the first place. What's more, Server C is actually a working linked server and definitely is in sysservers for Server A.
I originally tried this on yet another server pair and got a similar message referencing a server name that no longer exists. I stopped messing with that one, figuring it was some historical naming issue I didn't want to mess with. But now I'm stumped and intrigued. Can anyone help?
I have a report that I put links to other reports in the page header.
When I click on those links, I get the error:
"source of the report definition has not been specified"
If I move the links to the body of the report, they work fine.
Is this a bug or a limitation, and will we eventually be able to put links in the header?
Thanks!
BobP
How do you create a link on one report to run another report passing a parameter (or two).
what options do i have when i am unable to download resources from MS link:
I am trying to download Service packs for SQL server 2008 R2 from link [URL] But it says downloading and nothing shows up.
there is any alternative or what can be wrong with links?