| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Does anybody know how to determine which character set is currently used
in a database schema? I mean table names, column names, index names and
so...
Torsten Mueller
|
Yesterday 03:20 PM
Erland Sommarskog  | 1 | 2 |
| | | On Tuesday, August 1, 2000 3:00:00 AM UTC-4, Ephraim Hernandez wrote:
patelpratik88@gmail.com
|
06-09-2013 11:47 AM
patelpratik88@gmail.com | 0 | 16 |
| | | Hi,
I have the following output in a table:
UID FID nDate
-----------------------------------
178 100 2013-06-03 16:12:23.000
178 99 2013-05-30...
sumikumar@gmail.com
|
06-07-2013 02:57 PM
Gert-Jan Strik | 1 | 26 |
| | | If you are Planning to take Microsoft Exam 70-668, PRO: Microsoft
SharePoint 2010, Administrator Exam them you must read this Geat
Information about...
Emily Tyler
|
06-04-2013 12:32 AM
Emily Tyler | 0 | 24 |
| | | Hi!
This Is Emily Tyler. Microsoft Certified, & Microsoft Certification
Consultant. I am Feeling Happy to Join this group. I have written some
blog...
Emily Tyler
|
06-04-2013 12:16 AM
Emily Tyler | 0 | 8 |
| | | I was planning on using auditing on Sql Server but frankly
I'm disappointed with the rudimentary architecture of
auditing provided by Sql Profiler....
Jack A
|
05-23-2013 07:48 AM
tarun pant | 2 | 83 |
| | | We are using SQL 2008. I have been looking at BOL on Change Tracking but I'm
not sure it does everything I want. I would like to be able to identify...
David C
|
05-21-2013 06:37 AM
richardjenson7@gmail.com | 2 | 36 |
| | | Hello,
Is there anyway to audit in SQL Server??? I have read up on DDL
triggers but that seems to audit only server and database level
create,drop...
jai
|
05-21-2013 05:57 AM
tarun pant | 2 | 42 |
 | | Can not attach database,
Error message;
The file you've specified is not a valid SQL Server database file.
mybe Database some corrupt.
inter
|
05-17-2013 04:41 PM
tony37morris@gmail.com | 9 | 189 |
| | | Googler's Matt Cutts G+ https://plus.google.com/+MattCutts/posts
***************************
Restore Erased Photos ...
Isiah Rachyl Mallery
|
05-16-2013 06:52 AM
davegeeit@gmail.com | 1 | 35 |
| | | On SQL Server 2008 Enterprise 64-bit:
I am trying to attach a query to an email with DB Mail. It works in fine in
SSMS, but when I put the TSQL...
PatB
|
05-09-2013 09:49 AM
johnmerced@gmail.com | 6 | 64 |
| | | Hi,
I am asked to produce a report on who has accessed a particular database on an SQL server 2008 R2. The system (a third party with no internal...
tarun pant
|
05-09-2013 08:03 AM
charlespanth@gmail.com | 2 | 18 |
| | | Hi All,
I have 2 sql servers 2008.
Every night we backup the database on server A and then load it on
server B as an archive.
The problem is on...
woohoo30@hotmail.com
|
05-06-2013 07:40 AM
richardjenson7@gmail.com | 2 | 71 |
| | | Hi,
I have a corrupt MS SQL Server 2005 database which I
am trying to repair using:
DBCC CHECKDB ('MYDB', REPAIR_ALLOW_DATA_LOSS)
Unfortunately...
Benn
|
04-30-2013 12:20 AM
davegeeit@gmail.com | 2 | 189 |
| | | I just came across their site www.noction.com, looks like they are providing BGP optimization for service providers.
Has anyone deployed their...
hosting4fr@gmail.com
|
04-16-2013 04:50 AM
hosting4fr@gmail.com | 0 | 17 |
| | | Hi
I have a SQL Transactional replication module and I have an ETL process which pauses the distribution agent from the publisher to the Subscriber...
Query Builder
|
03-14-2013 04:49 PM
Erland Sommarskog | 1 | 61 |
| | | I recently put in a change to tempdb splitting it into 8 data files,
one per each processor over our SAN as well as putting in the -T1118
startup...
David Hay
|
03-08-2013 09:42 AM
bram.crombach@gmail.com | 73 | 194 |
| | | Hello,
In my report can anyone tell me how I can just display the last line which is a Total line and not display all the queried lines?
In other...
rhromyko@gmail.com
|
02-16-2013 09:28 AM
rhromyko@gmail.com | 1 | 73 |
| | | We have some sql databases that we have always used access as the
front end and have a lot of queries that work fine.
Now they have decided to...
sparks
|
01-08-2013 07:52 AM
sparks | 0 | 58 |
| | | Dedicated servers – POSTCY - Provide dedicated servers and dedicated server hosting services. We hosting company guarantee to offer the best...
postcy123@gmail.com
|
01-02-2013 03:23 AM
postcy123@gmail.com | 0 | 16 |
| | | we have a process that rebuilds indexes using "alter index rebuild online".
however if there is an existing select query running, it blocks the alter...
tomcaml@gmail.com
|
11-29-2012 03:45 PM
Erland Sommarskog | 1 | 18 |
| | | It may seem like an odd request, but I need to find out the date that the various tables in a database were FIRST updated.
This is because our...
jonno.armstrong@gmail.com
|
11-22-2012 02:12 AM
Erland Sommarskog | 1 | 16 |
| | | I'm going to be doing an upgrade from SQL 2000 Enterprise to SQL 2008 R2
Standard. Because I cannot upgrade Enterprise to Standard, I will...
Saucer Man
|
11-16-2012 11:14 AM
Saucer Man | 4 | 13 |
| | | Good afternoon,
I wonder if you can help with a query I have? I am new to SQL Server and am struggling a bit.
I'm not sure how best to present my...
adamcatley@googlemail.com
|
11-13-2012 03:07 PM
Erland Sommarskog | 1 | 10 |
| | | We have a program using SQL 2000 SP4 on a Windows 2003 server. The new
version of this program requires SQL 2005 or higher. We want to install...
Saucer Man
|
10-30-2012 07:41 AM
Saucer Man | 3 | 8 |
| | | VINIRMA Consulting Pvt. Ltd. is a 360degree Human Resource Management
Consulting and Staffing Services Organization with operations in UAE,
Qatar,...
VAM SYSTEMS
|
10-18-2012 05:37 AM
VAM SYSTEMS | 0 | 10 |
| | | I thought this might interest someone.
Webinar: Learn how to secure Windows Azure SQL databases
Date: Oct 4
Cost: Free
Presented by...
Sam B.
|
09-25-2012 06:58 AM
Sam B. | 0 | 10 |
| | | Looking to buy in large Quantities 10-20 or more! Email me directly at
buyingnetworks (AT) gmail (DOT) com
Microsoft Office, Server, Windows &...
cisco buyer
|
09-20-2012 02:45 PM
cisco buyer | 0 | 13 |
| | | Hi,
This is Mac , - Recruitment and Resources from SancroSoft USA Inc.
We have an urgent requirement as follows:
Please respond with resumes in...
Andy Robbins
|
09-12-2012 08:35 AM
Andy Robbins | 0 | 12 |
| | | Hi,
This is Mac , - Recruitment and Resources from SancroSoft USA Inc.
We have an urgent requirement as follows:
Please respond with resumes in...
Andy Robbins
|
09-12-2012 08:34 AM
Andy Robbins | 0 | 11 |
| | | Hi,
This is Mac , - Recruitment and Resources from SancroSoft USA Inc.
We have an urgent requirement as follows:
Please respond with resumes in...
Andy Robbins
|
09-12-2012 08:34 AM
Andy Robbins | 0 | 8 |
| | | Hi,
This is Mac , - Recruitment and Resources from SancroSoft USA Inc.
We have an urgent requirement as follows:
Please respond with resumes in...
Andy Robbins
|
09-12-2012 08:33 AM
Andy Robbins | 0 | 11 |
| | | It's here, live, and ready for download! We have just launched GreenSQL 2.2which supports Microsoft SQL 2012 and Microsoft SQL Azure cloud service....
Sam B.
|
09-08-2012 02:58 PM
Sam B. | 0 | 23 |
| | | Hello!
If I want to add a new user so he can use Windows authentication I assume
that I must do the following.
1. If I use SQLEXPRESS I don't have...
Tony Johansson
|
08-18-2012 07:26 AM
Erland Sommarskog | 1 | 301 |
| | | Microsoft's documentation is incomplete. It tells you how to install sql server from the command line from the command line. It only tells you how...
Scott
|
07-23-2012 11:52 AM
Scott | 1 | 116 |
| | | Hi All
I want a column in a table to contain only unique data, or NULL.
That is to say, I want a unique contstraint, except I want to allow
NULL...
neilsolent
|
07-22-2012 09:42 PM
Gene Wirchenko | 6 | 77 |
| | | I do daily full back up of a 150G bytes database to a local drive of
its server and it took 2 hours and 45 mins. This database is on SQL
2008...
wingman
|
07-12-2012 04:39 PM
Erland Sommarskog | 1 | 110 |
| | | Hi at all
My database has been defined as marked suspect.
How can i restore it?
I tried to restart sql server service, dbcc checkdb repair_rebuild,...
PIT
|
07-11-2012 04:17 AM
jameshkoler@gmail.com | 4 | 168 |
| | | If I write 'false' or 'true' instead of @complete in the sql below it works
fine.
I can fix this with string.format but first I try to fix this...
Tony Johansson
|
07-09-2012 04:47 PM
Erland Sommarskog | 1 | 80 |
| | | Thought this white paper may interest people working in the db security side of things.
http://bit.ly/KaL5YA
Securosis reports on Database Security...
Sam B.
|
06-04-2012 03:27 PM
Sam B. | 0 | 159 |
| | | I have a need to remove sp_makewebtask in sql server 2005. I am
logging in with a user that is in the sysadmin role however when I try
to run the...
tbone
|
05-29-2012 04:41 PM
tbone | 0 | 130 |
| | | Learn how to protect your sensitive information using Real-Time Dynamic Data Masking
When? Wednesday, May 23, 2012
(9:00 am PDT; 12:00 pm EST; 16:00...
Sam B.
|
05-20-2012 02:16 PM
Sam B. | 0 | 95 |
| | | Learn how to protect your sensitive information using Real-Time Dynamic Data Masking
When? Wednesday, May 23, 2012
(9:00 am PDT; 12:00 pm EST; 16:00...
Sam B.
|
05-20-2012 02:14 PM
Sam B. | 0 | 89 |
| | | can i run both on the same server?
mcnewsxp
|
05-15-2012 04:44 PM
Erland Sommarskog | 1 | 132 |
| | | Hi All
I am getting a wierd problem. When i try to install MSDE or SQL
SERVER 2000 Sp 3a, i get the error message "The instance name
specified is...
shantanu
|
05-02-2012 01:31 AM
zhangjianping | 4 | 111 |
| | | Questions at the bottom of this post
SQL Server 2008
Table has 3 columns:
CompanyName nvarchar(25),
IndustryCode nvarchar(3),
NetSales ...
mirandacascade@yahoo.com
|
04-23-2012 02:25 AM
Erland Sommarskog | 1 | 120 |
| | | I installed a 180 Day Trial Edition of Microsoft SQL Server 2008 R2
Standard Edition in Sept 2011 on a 64bit Windows 2008 R2 Server in a
HyperV VM. ...
DaveT
|
04-20-2012 05:13 PM
Erland Sommarskog | 1 | 108 |
| | | ITJobPro.com is the premier IT Job Board for information technology
professionals.
Upload your Resume (totally free) today and receive Free Job...
IT JobPro
|
04-19-2012 01:57 PM
IT JobPro | 0 | 97 |
| | | Hi
The DMVs give the top 10 long running queires.
We can also run a profiler & get the same data
Then why use Profiler when we can use DMVs. Can...
hiteshmirchandani@gmail.com
|
04-19-2012 12:38 AM
hiteshmirchandani@gmail.com | 0 | 137 |
| | | Hello,
I'm trying to run the stored procedure found in this white paper from
Microsoft.
However, after correcting the stored procedure "add_column"...
Olivier Matrot
|
04-11-2012 06:11 AM
benoit-dumesnil | 14 | 226 |
