I created a template that I use all the time. Normally I just drag-n-drop from the Template Explorer menu, however I'm wondering if I can assign a shortcut key to have it open? I see you can assign stored procedures and other items, but I can't find where/if I can do this for a template.
View 2 Repliesany shortcut strategies for table variables similar to shortcut strategies for temp tables? For example, the following SQL will create a temp table named #MyTable with all of the columns from student and then select the top 10 rows of student data into #MyTable:
select top 10 * into #MyTable from Student
Is there any type of similar or equivalent shortcut for table variables like:
select top 10 * into @MyTable from Student
if I want to select rows from Student into a @MyTable table variable then I need to create the @MyTable table variable with a column structure like a normal table which is more time-consuming than using the temp table approach.
I have Visual Studio 2012 (Ultimate) installed (Update 4) with SSDT (version 11.1.50512.0), Â I can see the template SQL Server Database Project, but where is the server-level project, SQL Server Project?
Previously, in Visual Studio 2008, I had a Category Database Projects with subcategories for SQL Server CLR, SQL Server 2000, SQL Server 2005 and SQL Server 2008. Â Each of those had a SQL Server 200x Server Project template.These seem to be missing in Visual Studio 2012.
Does anyone have a template for storing all SQL Server 7 information.
Database, filegroup, drive, ...etc. Any help appreciated
Paul.
From file, new, project, I did not see Project types.
Where is Report server project template?
How to make it appear?
I've managed to get the clubsite template from asp.net up and running, sorda (http://www.flysniper.com), I get a system error which I believe is related to the fact that my DB isn't working correctly.
I'm trying to configure it to work with ms sql server 2005 which is running on the same machine as the website.
I've followed the instructions of Scott Gu (http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx)
while trying to run aspnet_regsql.exe I get the following error
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727>aspnet_regsql.exe -S XXXXXXXXXX-U YYYYYYYY -P ZZZZZZZZZ -A all -d flysniper
Start adding the following features:MembershipProfileRoleManagerPersonalizationSqlWebEventProvider
......................An error has occurred. Details of the exception:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under thedefault settings SQL Server does not allow remote connections. (provider: NamedPipes Provider, error: 40 - Could not open a connection to SQL Server)
Unable to connect to SQL Server database.
I have tried several different things (shooting in the dark) to resolve this issue, including:
verifing that port 445 is avaliable on the firewall per these directions: http://support.microsoft.com/default.aspx?scid=kb;en-us;839269
configured SQL server 2005 to allow remote connections following these directions: http://support.microsoft.com/kb/914277
with no change in results.
Anything else I should look into?
Thanks in advance,
Mike
Hi,
is it possible to create a report server project template ? This project must have 2 datasources and 1 specific report
I wanted to use the Export Template, but it isn't available. I can only use it in Developpement Studio not in BIDS.
Thanks to help me
Cédric
Hi,
I have SQL2K5 standard edition and I planned to use the CLR-UDT feature of SQL 2K5. Unfortunately, after following these links:
http://www.pcquest.com/content/enterprise/2005/105041103.asp
http://msdn2.microsoft.com/en-us/library/a8s4s5dz(VS.80).aspx
I found that there is no SQL SERVER project template in my installation of Visual Studio 2005(which came with the SQL2K5 CD). How can I get this particular template? Is there a work around?
I need to create the UDTs on SQL SERVER 2005.
Thanks
When I open QA on my development machine, I almost always go to the same db.Is it possible to create a shortcut for QA which tells it to go to that db,and also provides the login and password? Thanks,Neil
View 4 Replies View RelatedI have downloaded and installed this program, trying to get into programming, and i cannot find a shortcut to lauch it... Is there even a shortcut... all i get when i go to Start > All programs is configuration changes... Please help
View 3 Replies View RelatedIs there a way to have the results from a query return to a single string? Basically concatenating all values returned to a string?
View 2 Replies View RelatedHello,
i have installed sql 2005. i dont see enterprise shortcut anywhere. i even went to mmc console but could not see under 'add..' i could only see SQL configuration shortcut.
what am i doing wrong? :(
I was searching the group for posts on the subject of format files andI came across a message by Erland Sommarskog dated 2003-07-07 withsubject line "Re: BCP Format File". In this example, he used aFORMATFILE where the "prefix length" and "host file data length"fields were both zero for all columns.This convention seems to simplify the task of creating format files.Is this shortcut generally applicable or was it a special case? Doesthis mean that SQL Server can always establish the actual lengths inthe data file by looking up the destination table's schemainformation?
View 3 Replies View RelatedHello,
i have installed sql 2005. i dont see enterprise shortcut anywhere. i even went to mmc console but could not see under 'add..' i could only see SQL configuration shortcut.
what am i doing wrong?
Private Sub DataGridView1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles DataGridView1.KeyDown
'Create a new row after pressing enter key
Dim newRow As PSystemDBDataSet._BaseInformation_FTRow
newRow = PSystemDBDataSet._BaseInformation_FT.New_BaseInformation_FTRow
If (e.KeyCode = Keys.Enter) Then
PSystemDBDataSet._BaseInformation_FT.Rows.Add(newRow)
PSystemDBDataSet._BaseInformation_FT.IDColumn.AutoIncrement = True
Else
PSystemDBDataSet._BaseInformation_FT.IDColumn.AutoIncrement = False
End If
'Post the information to final results and tax information using shortcut keys
If (e.Control And e.KeyCode.ToString = "C") Then
MsgBox("This is it")
End If
End Sub
The control C code that i code cannot work. Any ideas??
Is this a shortcut for an outer join and if so, why can't I find any info on it?
select id, name
from table1, table2
where id *= id_tbl2
instead of
select tb1.id, tb1.name
from table1 as tb1
outer join table2 as tb2
where tb1.id = tb2.id_tbl2
and what happens in the first example if you try to join more tables?
Is there a keyboard shortcut to add a <NULL> value into a field on my SQL Server 2000 database table, using SQL Server Enterprise Manager
View 1 Replies View RelatedI have installed in my machine SQL 2005 with SSIS components, and the Visual studio 2005. The installation process was successfully and all components seem to be on the machine, but I did not find the shortcut to allow me running SSIS environment.
When I re-run the SQL setup the SSIS components is there but is unable to be used.
Any idea how to solve this issue?
Thank you,
Marian
Is there a simple way to avoid having to use a data conversion task to convert Unicode data (from DB2) to ANSI format (for insert to Oracle)?
I'm hoping that there is a way to set the code page property on the OLEDB driver so that it implicitly converts to the format I want instead of having to explicitly force the conversion in the package.
Thoughts? suggestions?
-Clayton
Anyone know if there is one and if so what it is? I know I can type directly into a text box in a table, but what if I want to edit the contents? Equivalent of F2 in Excel...
Thanks
I have a simple WSS 2.0 SharePoint site for my SSRS deployment which I would like to link my users to from the SSRS home page. Is it possible to add a link or shortcut to my SSRS home page without embedding it inside of a document or report?
View 1 Replies View RelatedThere are a few features in the new SQL Server - Reporting Services that I really need in production. I have tested everything and it works great. I am running the CTP version since Microsoft is saying they aren't releasing the release version until 3rd quarter 2008.
Since Microsoft won't sell SQL 2008 until 3rd quarter, can I run the CTP in production until the release and then purchase SQL 2008?
Jim
Hello - does anyone have experience w/SQL Server 2005 in a virtual environment? I'm considering this for a production environment but not sure if performance will suffer. Our databases will have a lot of writing but not too much reading. A SSRS solution is currently the only app. connecting to the SQL db. Max users to server at any given time will be very low (~10 users max). But the databases are pulling in data from other, outside multiple data sources on a daily basis.
Any pointers to documentation or any advice?
Thanks,
A Brown
Hi,
anyone knows if there's an easy way to insert new GUIDs into uniqueidentifier cells when editing data in table on Management Studio Express? or Visual Studio 2005 Server Explorer? I can't find a shortcut, and copying from external tools is pain..
I suppose it's possible to build a VB macro in Visual Studio, would it work when editing table data?
Thanks in advance!
Hello!
Recently, I set up server with Windows Web Server 2008 RC1, SQL 2008 Express beta, .NET 3.5, IIS 7.
I'm running ASP.NET web application with SQL database. Everything works fine until the first application state on the server expires. After that, any postback that starts a new application state on the server and connects to the database, results in the following error:
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
Is this a bug that will be fixed in release of Windows / SQL or am I doing something wrong?
Many thanks for help,
Jan
Hi all,
New to this so please be patient and please help.
I have developed an SQL 2005 Express command line option install for our company which has been working seamlessly for the last 18 months.
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
I downloaded the €œMicrosoft SQL Server 2008 Express CTP, February 2008€? from http://www.microsoft.com/downloads/details.aspx?FamilyId=749BD760-F404-4D45-9AC0-D7F1B3ED1053&displaylang=en
I simply replaced the 2005 file €œSQLEXPR.EXE€? with the 2008 file €œ€?, recompiled the installation and tested only for it to fail. I than read the 2008 books online and noted the change in command line options.
http://www.microsoft.com/downloads/details.aspx?familyid=19DB0B42-A5B2-456F-9C5C-F295CDD58D7A&displaylang=en
http://msdn2.microsoft.com/en-us/library/ms144259(SQL.100).aspx
I then changed the command line to suit the Microsoft 2008 books online, recompiled the installation and tested only for it to fail once more.
Interestingly I tested the install from the default GUI and at the point of adding the €œsa€? login credentials it fails to allow the installation to proceed. Strangely by selecting the windows authentication credentials, €œnext€? than €œback€? it now allows me to add the €œsa€? login credentials and continues to install correctly as required.
I hope I have explained this clearly enough.
1. Is this a bug in the €œMicrosoft SQL Server 2008 CTP, February 2008€? installation?
2. If so is this causing the command line install options to fail?
3. How do I obtain a version of €œMicrosoft SQL Server 2008 Express€? that will work installing from the command line?
Thanks in advance.
Somehow I have saved an sp as a template - how do I delete it ?
View 4 Replies View RelatedI need to import data from a CSV file into a db I'm designing. I figured I'd use DTS (which I understand now uses VS in the form of a 'Business Intelligence' (BI) project). My problem is that my only choices for BI projects are:
Analysis Service Project, Import Analysis Services 9.0 Database, Integration Services Project, Report Server Project Wizard, Report Model Project, Report Server Project.
No "Data Transformation Project".
I have SQL Server 2005 Developer's Edition. Might it be that DTS is not included in that version?
If I can't use DTS, what choices do I have?
Hi! I'm new to SQL Server 7 and I hope I could get some help. I'd like to duplicate an empty database and use the duplicate for the transactions. I want the empty database to somehow act like a template so, whenever I want to, I could create a new instance of it. Problem is I don't know if it is possible to do that on SQL server (it's possible in Access). If it is possible, I hope any of you could tell me how. Thanks.
View 1 Replies View RelatedHello,
I'm having a hard time trying to figure out how to run the logtemp.sql script that is included with IIS4 for ODBC logging. Any help would be appreciated.
In Enterprise Manager when I bring up Trigger Properties there is an active button titled "Save as Template". But when I switch to an existing trigger the button is disabled. Oddly, the Help file for the dialog box doesn't even mention this button.
Anybody know what this does, how it works, or why it would be usefull? Any references to The Holy Book would be helpfull.
HI,
how can I specify the number of records that have to be sent back dynamically in an Xml Template?
I am currently busy developing a client-server application that pulls data from an Sql Server via Xml. If the client application has a bad connection to the server, the program has to get the data in small portions.
When I use:
SELECT TOP @amount *
FROM employees
I get the error: syntax near '@amount'.
The query fails as wel when I tried to use:
SET ROWCOUNT @amount
SELECT *
FROM employees
SET ROWCOUNT 0
This works fine in Sql analyser, but sql doesn't allow the integers to be parameters and casting them to int does not work either.
thanks for your help!
Hi all. How to make a template header for reports please? So that everytime I make a report, ill just call the template in the header.
Thanks.
-Ron-