Hello, Everyone.
I am using Sql Management Objects (SMO) in Visual Studio 2012 C#.
I am attempting to instantiate a new StoredProcedure object from the db.StoredProcedures Collection.
When I try to find a stored procedure in the [dbo] schema. It works fine.
StoredProcedure sproc =...
Hello, All.
I have a query where I am looking for tables that end in _AM.
SELECT sch.[name] AS SchemaName, tab.[name] AS TableName
FROM sys.Tables AS tab
JOIN sys.Schemas AS sch
ON tab.schema_id = sch.schema_id
WHERE tab.[name] LIKE '%_AM'
AND sch.[name] = 'dbo'
I get back:
dbo...
Hello, Everyone.
I am new to SMO, so I do not know the accepted methodologies.
From my attempts, it appears that I am way off track on how to use this set of tools. Suggestions and guidance appreciated.
This is the error.
"An unhandled exception of type...
I was curious if there was a way to query in tsql whether or not a table's key in clustered or not using table_name or object_id or whatever is best?
Here is a table that has a clustered primary key set. I know that there are tables in my database that are Not clustered on the pk and I will...
Hello, Everyone.
I am trying to do some automated re-creation of some tables in Sql Server 2008.
When you right click a table, you can choose 'Script table as' and get everything you need to know to re-create the table.
I was curious if there was a way to do this using tsql that I could read...
Good day everyone.
My boss said to me 'Do not put a clustered index on the identity. I want to look at the data later and decide what to cluster on.'
I have a snippet of code. It functions, but I am not sure that I completely grasp what is happening when I run it.
Here is my snippet that I...
Hello, All.
I have an html table. The first column is a drop list with the days of the week in it Sunday through Saturday. Second column is two text boxes for start time and end time. The other column is a drop list (true/false). In the html, each row (other than the header) has a GUID for...
Hello, Everyone.
For years I went to the File Menu and chose Help->About and that would tell me everything about my version on the About Page.
Then Outlook switched to the Ribbon and Tabs and got rid of the File Menu.
At that point, I would click the File Tab and 'Help' was an option there...
Hello Everyone.
I have been given an assignment that has me perplexed.
I am curious if there is a way to get the result set of a dynamic query returned to the calling stored procedure. Since dynamic sql runs in it's own context, I can't just assign variables in the @SqlString. I am open to...
Hello, everyone.
I am setting a variable equal to a data point in a cursor row. Snippet below.
Is there a way to get a persistent variable assignment to the variable 'id'?
This is clearing out when I close the cursor.
I know that it is getting set from the cursor since it is showing in the...
Hello, Everyone.
A little bit new to Crystal Reports.
I have an old report. I am being told to duplicate it with some small modifications to the source query.
I create the report using the Report Wizard. It's a cross-tab report. The wizard creates the report with the cross-tab in the...
Hello, All.
Is there a way to make these two lines of code one line.
comm.Parameters.Add(new SqlParameter("@p1",SqlDbType.VarChar,3));
comm.Parameters["@p1"].Value = textBox1.Text;
Thought it would be simple.... like
comm.Parameters.Add(new SqlParameter("@p1",SqlDbType.VarChar,3).Value =...
Hello, Everyone. I am new to Crystal. I am coming from SSRS, so the tools are quite unfamiliar to me.
I have a report that looks like this.
Jones $5
Jones $10
Jones $20
Smith $1
Smith $5
Smith $5
Smith $10
Carter $5
It is a simple "Select LastName, Amount From myTable".
I want to...
Hello, Everyone.
I am using MS Access 2010 Version 14.0.61.29.5000.
I have a form that I am supporting. It has several tab pages. I need to get a combox on page3 to update when I change a combobox on the main tab (page1).
I tried to do this on the onchange event but ran out of intellisense...
Hello, All.
I have a citrix server that filled up. It had 132KB left. I cleared out the temp folder freeing up about a Gig so that production could move forward for a little while.
I really need to increase the size of the allocation for c:
This is the current allocation:
c: 1.07 GB Free of...
Hello, Everyone.
I am supporting a production environment while the network guy is on vacation.
I go and look (remote in to a server) and see this:
C:\ 13.8 GB Free of 71.9 GB 59 GB of files +13 GB Free ~ 72 GB Drive
E:\ 1.58 GB Free of 64.6 GB 46.8 GB of Files + 1.58 GB Free != 64.6...
Hello, All.
Alright, I have a project solution (sln file) for BIDs on a server.
When I typically work on SSRS reports, I just go double click that project (sln file).
Today I was toying with the idea of starting a new project, so I launched BIDs from my start menu.
I added one of the server...
Hello, Everyone.
I am maintaining javascript code from another developer on Internet Explorer 8.
I have a recordset that returns only one field and that field is null.
A record exists but the value of the field is null.
I tried testing for null in the field value but I am missing something...
Hello, Everyone.
I am using SQL Server 2008.
I am reviewing code from a previous developer and I do not understand something I am seeing. I get the concept but the specifics of how it works are escaping me. I was trained to use JOIN to join tables, not list tables and force comparison in a...
Hello, Everyone.
I am using BIDS 2008 with SQL Server 2008.
I am troubleshooting someone else's report that is giving bad results.
Firstly, it has a parameter where 'Allow Multiple Values' is selected.
When passing the multiple parameters to the report, the author did not...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.