New answers tagged

5

In Azure, you're not limited to public networks. They have Azure Virtual Network to create a private network between your VMs, then using Azure VPN Gateway you can connect via P2S VPN into this private network, getting a local VN IP address, and connect to your Azure SQL Server instance with SSMS. After configuring private VNs, you can use Azure VN NAT to ...


0

I wrapped an if statement around my whole procedure if RIGHT( convert(varchar(11),CURRENT_TIMESTAMP,120),2) = 22 do something else end


0

this may be too late, but there seems to be a better answer for this question. I was searching for the same thing; how do I view the connection string to a particular SQL Server database. I read you cannot do it within SQL Server Management Studio, but you can retrieve the connection string Visual Studio uses, as suggested by another user. In Visual Studio, ...


0

Normally DBAs create an automated function or have tools to rebuild the indexes. This one is a functional version to rebuild all indexes to all tables in your schema: DECLARE @tableSchema varchar(max), @tableName varchar(max), @tsql nvarchar(max); DECLARE cur CURSOR FOR SELECT TABLE_SCHEMA, TABLE_NAME FROM Information_Schema.tables where ...


0

If you want to check database size of particular database using SSMS Gui Go to Server Explorer -> Expand it -> Right click on Database -> Choose Properties -> In popup window choose General tab ->See Size Source: Check database size in Sql server ( Various Ways explained)


Top 50 recent answers are included