I have created a new database using Visual Web Developer and wanted to manage it using either the SQL Server Management Tool or MS Access via ODBC. Niether of these tools will connect to the database. The database file , called srx.mdf, the connection string is Data Source=.SQLEXPRESS;AttachDbFilename=C:InetpubwwwrootSRExchangeApp_Datasrx.mdf;Integrated Security=True;User Instance=True I can however connect successfully to the master file, the conenction string for this is Data Source=.sqlexpress;Integrated Security=True Any help appreciated.
I need to find a way to identify SPIDS where queries are connected to certain databases using the 4 dot notation instead of actually being connected to the database in question.
For instance, I connect and my default database is MASTER. In MASTER, instead of typing USE MyDb ahead of my query, I just type my query as:
SELECT Col1, Col2 FROM MyDB.dbo.MyTable
The above is the simple scenario. We usually have queries connecting 3 or 4 user dbs together. So database1 might have a query pointing to database2. What I need is a way to identify the SPIDS that are connecting to database2 despite being in database1.
As SQL Server 2016 category is not created so I am posting this query in SQL Server 2014 window.
I have enabled Query Store in SQL Server 2016 using ALTER DATABASE and later tried with Properties of Database too. But I am not able to see the Query Store subfolder under database.
i wanted to test routines using my local sql server engine and thought I could backup the mdf ldf file on the true network sql server in which I am listed as a dbowner with full permissions. In fact i can add users for the at db etc.The backup allows me to browse to a local folder
with the following being the default C:Program FilesMicrosoft SQL ServerMSSQL10_50.CMS_PROJECTMSSQLBackup
i name the file and it executes properly but when i try to restore that file to my local db that path is not even visible to me.In fact when i use exploreer I cannot even find the folders after Microsoft SQL Server!I search for .bak but nothing.How can I see that folder construction in the sql browser but never in explorer -
I am wondering if I can show the Excel window when the SQL server agent job runs. The SSIS package contains a script task that opens Excel and does some formatting. I just need to monitor the formatting of these Excel files.
1. I created a maintenance plan using Visual Studio 2013 (nothing fancy pretty basic) 2. Using ssms 2014 I imported it (the dtsx file) under the Integration Services and it appeared there successfully 3. I connected to the Database Engine again using ssms 2014 - my expectation was to see it under the Management > Maintenance Plans folder but it was not present.
Hi, I have RS 2000 running on windows 2003 server. I want user to subscribe to reports and receive reports via email. Initially SMTP was not installed for IIS 6.0, so I installed it and the right way (I had done it on different machine before and was succefull in that) but on this particular machines ...I don't see "Default SMTP Virtual Server" node when I open IIS manager. This is the third day I am working on this issue ..please help me out guys, prashant
I recently imported some Access tables into SQL Server. I can go into enterprise manager and return all rows and the data is there.
I build an ASP page to edit the data. After the connection the data for the record is displayed in a form. For some reason some fields are not coming through?
Is this a problem when converting to SQL Server. It just doesn't make sense that the table in Enterprise manager says the field is populated but when I do a pull via ASP the data doesn't come through.
Does anyone know anything about this?
Any help or pointing in the right direction would be greatly appreciated.
I am using an expression to hide values in a row based on a date field ( if date is bewtween this date and that date show value, otherwise hide it). My problem is now I need to sum all the values, even though some are not visible the sum is still adding them. Is there an expression to check for only "visible" rows??
I got a Report with a lot of columns and if the user scrolls, I would like to keep the first 2 columns visible. Excel offers a function like this is there something like this in Reporting?
i created two new instances of SQL Server and created 2 triggers on each of these instances.
I go to object explorer under the triggers plus sign and there's no triggers there. But these instances recognize that the triggers are there because when i try to recreate them, i get a trigger already exist error message.
Is there a problem with my instances or is there something i need to change or configure?
Hi all, I have a 1 TB network drive on a Windows 2005 sql server that is visible at the OS level.I am trying to use this for my SQL backups but this drive is not visible from SQL server. All the other drives appear fine except this drive. The OS team already checked everything and as its visible at the OS level they point to SQL server as the one having problems. Any suggestion would help.. -Thanks all.
When you go to Sql Management Studio->Object Explorer and select Tables and then System you don€™t see any at all. Why are not visible system tables for each user database as previously did Sql Server 2000 ? They are hidden or there is other stuff? Any thought or view would be very appreciated.
Is there anyway to check if a textbox (or detail row, etc) is visible? I'm envisioning something like an 'isVisible' function. I'm trying to set a filter in the detail section based on a toggled visibility.
I am trying to do some time series analysis on data that I have. I've read that the best way to do this is to use CLR to write the manipulation code in .Net and then load the assembly into SQL rather than extracting the data, manipulating it and putting it back again.
I'm using crystal reports with visual studio 2003 to do my reporting. The problem I am facing is that the CLR stored procedures I create using SQLExpress are not visible from my SQL explorer built into Visual Studio 2003. I can create stored procedures using standard transact sql and these are visible, but the CLR stored procedures are not.
I've noticed when I browse the stored procedures in my SQL Management Studio that the image of the stored procedure has a padlock shown in the icon, as if they are locked?
Do I have to explicitly enable a security attribute on CLR stored procedures to make them visible?
I am trying to set the TaskResult in my DataFlow ScriptComponent, but the Dts object is not visible. Dts.TaskResult = Dts.Results.Failure The above line works fine in my EventHandler script, but the Dts object seems to be out of scope when I try to use it from my Dataflow. One thing I have noticed is that my DataFlow ScriptComponent inherits from 'UserComponent' I have tried adding Microsoft.SqlServer.ScriptTask reference, but can not see it in the reference list - Strange? Any help appreciated. Regards, Paul.
I have SQL express installed in my server and I created a stored procedure using SQL server management studio express, but when I refresh my stored procedures the one I created does not show. Please help. Your valuable feedback is greatly appriciated.
I have created some tables and relationships between them by using MS SQL Server Management Studio Express. The relationships are between a field named OId, which is not a part of the primary key but it is typed as an unique key. And a field named ParentTableOId.
When I open the two tables that have this relationship in the "Design Query in Editor" is not the relationship there. Anybody who knows why?
When defaulted to Visible or Invisible, +/- displays correctly. But when using the Expression, + is always showing as the default even when a group is expanded. Is this expected? TIA.
I have defined a variable varFileName and when I go to the Expression Builder in my Connection Manager Properties I can't see it and even when I type the name it says the variable is not existent or in a different scope. I have set the scope to be the very same package, that's for sure. Can anybody please tell me, as I can't solve this mistery, why the Builder does not see the var???
I have a report that I want users to navigate to and I want them to see the parameters of the report, but I don't want them to be able to change them. Is this possible?
I am new to reporting services and really need some help.. Im trying to simply my requirement using this scenario: Lets say
I want to display Sales for the current year (i.e from the start of the year january to the month we are currently at). The next requirement is to group these sales, by Area , Region , Zone...
Top leve l = Zone , then Region then Area.
I need the user to be able to control this using a parameter (i.e User can select "View Area Level" or "View Region Level" or "View Zone level")
How can this best be achieved ?
My idea was using row groupings and controling visibility using the parameter.. The problem is.. If i want to view ONLY the area level and not see anything above, can I turn visibility off of the Zone and Region and still see the inner group (area)
Area Level (default view)
Jan Feb Area 1 100 100 Area 2 200 200
Region Level Selected
Reagion 1 Area 1 100 100 Region 2 Area 2 200 200
Zone Level Select
Zone 1 Region 1 Area 1 100 100 Region 2 Area 2 200 200
I have created a database on my local machine using SQL Server Express 2005. I am trying to export data from an excel file into a table in this database but when i see tasks available for the database there is no option of import data like I assume there should. Only the following options are visible. Detach Shrink Back Up Restore Generate Scripts
Any solutions on how I can get my excel file into the table.
I have created some tables and relationships between them by using MS SQL Server Management Studio Express. The relationships are between a field named OId, which is not a part of the primary key but it is typed as an unique key. And a field named ParentTableOId.
When I open the two tables that have this relationship in the "Design Query in Editor" is not the relationship there. Anybody who knows why?
I have matrix which has many rows. Is there any way to keep header remain visible while scrolling?
I tried to set "Group header should remain visible while scrolling" in my columngroup property but got the error:
[rsFixedHeadersInInnerDataRegion] The matrix €˜matrix1€™ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.
I have matrix inside a table which I set table property FixedHeaderto False but still got the same error. I can't find other places who set fixedheader properties. Any suggestion would be very appraciate!
In my production server all the jobs are scheduled. but though sa user id sometimes the steps in the jobs are not visible but it is working, sometime it is visible in the sql server management studio. do i have to check any settings or change any settings.