Is there any way to check GRANT VIEW DEFINITION ?
Tue, 09 Mar 2010 19:31:34 +1100
There is a request to grant privilege to a particular user for viewing
stored procedure source code for all databases.
We searched the web and applied the following script:
USE master
GO
GRANT VIEW ANY DEFINITION TO User1
Is there any way to check the view definition has been granted ? We
have tried ...
|
SQL Server Drops connection after long timeout with replication partner
Tue, 9 Mar 2010 09:14:48 +0100
Hello,
I have both SQL server 2005 that have replication set-up between eachother.
It seems that when my site-to-site VPN drops for a medium period (such as
1hr, 2hr) bothe servers no longer respond to client connections.
Restarting the "SQL server Browser" service on both machines instantly
resolves the p ...
|
Long execution time for UPDATE tbl SET @var = col = {expression} under SQL2000
Mon, 8 Mar 2010 16:47:27 -0800
Folks:
We have SP queries like:
UPDATE tbl
SET @var = col = col + 1
WHERE keycol = x; -- update single row, indexed
This query can sometimes sit for several _minutes_ on a MSSQL2000SP4 box,
but we don't see similar delays on a MSSQL2000SP4+postSP4hotfixes box under
large testing load.
Is the ...
|
Primary Key - string or integer
Tue, 9 Mar 2010 10:49:50 +1100
What do you thing how slow will that be if string is used as primary key
field type?
I know most of the primary key defined as integer type (eg.auto-increment).
We are using string as primary key field type: VARCHAR(36).
We use the GUID type string.
...
|
no value to be substituted by NULL word
Mon, 8 Mar 2010 14:07:54 -0800 (PST)
Hi,
I have a table with 5 columns where the last column doesn't have any
values. I have to write a query to pull all information from the
table (select * from table) but the last column should show word
"NULL" as opposed to nothing. The "NULL" word should only be shown in
the query result set and nothing shoul ...
|
sa not found
Mon, 8 Mar 2010 12:16:01 -0800
SQL server was installed on a server recently for a Cisco application. This
application's setup connects to the SQL Server and creates a database. The
application setup completed after creating a new database. Now when I logged
in I found that the sa login is now missing under Security tab. This is SQL
2005. ...
|
A Question about SQL Server 2008 Installation
Mon, 8 Mar 2010 13:49:42 -0600
There are 6 cumulative updates after SQL Server 2008 SP1. If I setup a new
server, after install SP1, should I install each of the cumulative updates,
or just install the last one? In other words, does the last update include
all previous updates?
Thanks,
Lijun
...
|
|
|
VS2008 and sql server - from 2005 to 2008 ?
Mon, 8 Mar 2010 20:37:43 +0100
I installed VS2008 SP1 on one machine, somehow I have also sql server 2005
and 2008. On other machine I installed SP1 and only have 2005 sql server. I
checked the rest of downloaded plugins and other VS stuff, but can't figure
out how I got the server 2008.
...
|
Identity column not being reseeded
Mon, 8 Mar 2010 09:44:01 -0800
Hi,
We are in the process of migrating from one DC to another. I setup a
transactional replication using SQL backups for a database that only has two
tables which are very actively updated. Here are the steps that I followed in
the order:
1) Setup distributor.
2) Restored full backup followed by T-Log b ...
|
DateTime. Stored with timezone information or not
Mon, 8 Mar 2010 13:52:16 +0100
One thing I have been blessed from until now is to deal with datetimes
for different time zones.
Are datetime saved as they are (not taking timezone into account) or
are they converted to UTC?
If it does I guess the timezone the server is running in is used (or
more correctly what timezone Windows tha ...
|
