Counting Data Elements
DBAs,What is the best way to determine the total number of data elements/fields in a SQL Server database? Thanks!
2004-03-11
1 reads
security
RE: calling a stored procedure
DO you want something like this:CREATE PROCEDURE Return_Example @Value INT OUTPUT AS SELECT @Value = MAX(date) FROM --this can be any logic you want including complex IF logic go declare @Value numeric exec return_example @value=@value outputselect * from table where datediff(d, column , getDate() ) > @value hope this helps
2004-03-10
2004-03-10
2004-03-08
optional parameter in select query
hi i have a situation in stored procedure where i get partial parameter so i have to use select query with like option but with parameter i will have to execute it in a string but when i execute it i get following errorServer: Msg 403, Level 16, State 1, Line 4 Invalid operator for […]
2004-03-05
how to deny access to Stop SQL server from enterprise manager
I created login and gave restricted rights (dbreader) to user for development database. The user with restricted rights can click on the server and he has the options to Stop or Pause the server. How can I deny the access to this options?Is it possible do not show to users with restricted rights the option […]
2004-03-04
1 reads
RE: SQL Login Security
If your users are connecting through an application server you can put the SQL Server behind a firewall and just allow access through the firewall to the app server IP address, thus denying enyone else access.
2004-03-04
RE: Restarting SQL Server every night
net stop mssqlservernet start mssqlserverand schedule it at windows level (at command).
2004-03-04
RE: Passing a querystring to a stored procedure?
Thanx for the help...... If you can believe it, I had an 'end if' in the wrong place which caused the re-submit of the querystring not to execute..... DOH!
2004-03-03
RE: Reflexive treeview table - how to get root from child?
There are a lot of ways to do that but one of my favorites is this oneHTH
2004-03-03
Blogs
Enabling an Index: #SQLNewBlogger
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers